Algorithmic Trading Model for Cramer COVID-19 Index Using Python Take 2¶
David Lowe¶
June 1, 2020¶
SUMMARY: The purpose of this project is to construct and test an algorithmic trading model and document the end-to-end steps using a template.
INTRODUCTION: CNBC’s Jim Cramer, the host of Mad Money show, presented a list of stocks on April 27th that he believes will work well in this coronavirus-plagued market. The ‘Cramer COVID-19 Index’ contains 100 companies that touch 17 sectors where investors can expect a positive return in this volatile market environment. The project aims to analyze these 100 stocks and develop strategies for trading these stocks, either individually or in groups.
In iteration Take1, we constructed the necessary code segments for downloading and visualizing the index and the stocks. The script leveraged various data sources, both free and paid subscriptions, for pulling the required dataset together.
In this Take2 iteration, we will build on the previous analysis by constructing a dual moving-average crossover trading model (20-day and 50-day) and applying the model to the 100 stocks in the index. For each stock, we will identify the entry and exit dates starting January 1, 2019.
NOTE: This script calculates the index value by using the number of outstanding shares from each company. Such an approach may not match how CNBC calculates this index (https://www.cnbc.com/cramer-covid-19-stocks/). This script is for educational purposes only and does not constitute a recommendation for buying or selling any stock mentioned in this script.
ANALYSIS: Refer to the list of entry and exit points for each stock in the index under Task 3.
CONCLUSION: Refer to the list of entry and exit points for each stock in the index under Task 3.
Dataset ML Model: Time series analysis with numerical attributes
Dataset Used: IEX Cloud and Quandl
An algorithmic trading modeling project generally can be broken down into about five major tasks:
- Prepare Environment
- Acquire and Pre-Process Data
- Develop Strategy and Train Model
- Back-test Model
- Evaluate Performance
Task 1. Prepare Environment¶
In [1]:
import os
import sys
import smtplib
import numpy as np
import pandas as pd
import requests
import json
from email.message import EmailMessage
import matplotlib.pyplot as plt
from datetime import datetime, timedelta
from time import sleep
from dotenv import load_dotenv
In [2]:
# Define the function for sending the status notification emails
def email_notify(msg_text):
sender = os.environ.get('MAIL_SENDER')
receiver = os.environ.get('MAIL_RECEIVER')
gateway = os.environ.get('SMTP_GATEWAY')
smtpuser = os.environ.get('SMTP_USERNAME')
password = os.environ.get('SMTP_PASSWORD')
if (sender is None) or (receiver is None) or (gateway is None) or (smtpuser is None) or (password is None):
sys.exit("Incomplete email setup info. Script Processing Aborted!!!")
msg = EmailMessage()
msg.set_content(msg_text)
msg['Subject'] = 'Notification from Algorithmic Trading Modeling Script'
msg['From'] = sender
msg['To'] = receiver
server = smtplib.SMTP(gateway, 587)
server.starttls()
server.login(smtpuser, password)
server.send_message(msg)
server.quit()
In [3]:
# Begin the timer for the script processing
startTimeScript = datetime.now()
# Set up the verbose flag to print detailed messages for debugging (setting True will activate!)
verbose = False
# Set up the sendNotification flag to send progress emails (setting True will send emails!)
notifyStatus = False
# Set up the parent directory location for loading the dotenv files
useColab = False
if useColab:
# Mount Google Drive locally for storing files
from google.colab import drive
drive.mount('/content/gdrive')
gdrivePrefix = '/content/gdrive/My Drive/Colab_Downloads/'
env_path = '/content/gdrive/My Drive/Colab Notebooks/'
dotenv_path = env_path + "python_script.env"
load_dotenv(dotenv_path=dotenv_path)
# Set up the dotenv file for retrieving environment variables
useDocker = True
if not useDocker:
env_path = "/Users/david/PycharmProjects/"
dotenv_path = env_path + "python_script.env"
load_dotenv(dotenv_path=dotenv_path)
# Configure the plotting style
plt.style.use('seaborn')
# Set Pandas options
pd.set_option("display.max_rows", 120)
pd.set_option("display.width", 140)
In [4]:
if notifyStatus: email_notify("Task 1. Prepare Environment has begun! "+datetime.now().strftime('%a %B %d, %Y %I:%M:%S %p'))
In [5]:
# Check and see whether the API key is available
alphavantage_key = os.environ.get('ALPHAVANTAGE_API')
if alphavantage_key is None: sys.exit("API key for Alpha Vantage not available. Script Processing Aborted!!!")
# Check and see whether the API key is available
iexcloud_key = os.environ.get('IEXCLOUD_API')
if iexcloud_key is None: sys.exit("API key for IEX Cloud not available. Script Processing Aborted!!!")
# Check and see whether the API key is available
quandl_key = os.environ.get('QUANDL_API')
if quandl_key is None: sys.exit("API key for Quandl not available. Script Processing Aborted!!!")
In [6]:
# Specify the parameters for the trading strategy
fast_ma = 20
slow_ma = 50
model_start_date = datetime(2019, 1, 1)
print("Starting date for the model:", model_start_date)
stock_start_date = model_start_date - timedelta(days=int(slow_ma*1.5)) # Need more pricing data to calculate moving averages
# model_end_date = datetime(2020, 1, 1)
model_end_date = datetime.now()
print("Ending date for the model:", model_end_date)
Starting date for the model: 2019-01-01 00:00:00 Ending date for the model: 2020-05-29 22:46:41.852454
In [7]:
if notifyStatus: email_notify("Task 1. Prepare Environment completed! "+datetime.now().strftime('%a %B %d, %Y %I:%M:%S %p'))
Task 2. Acquire and Pre-Process Data¶
In [8]:
if notifyStatus: email_notify("Task 2. Acquire and Pre-Process Data has begun! "+datetime.now().strftime('%a %B %d, %Y %I:%M:%S %p'))
In [9]:
dataset_path = 'https://www.dainesanalytics.com/datasets/cramer-covid19-index/Cramer_COVID-19_Index.csv'
stockIndex = pd.read_csv(dataset_path, sep=',')
stockIndex.set_index('Symbol', inplace=True)
stockIndex = stockIndex.sort_index(ascending = True)
# Take a peek at the dataframe after import
stockIndex.head(10)
Out[9]:
| Name | |
|---|---|
| Symbol | |
| AAPL | Apple |
| ABBV | AbbVie |
| ABT | Abbott Labs |
| ADBE | Adobe |
| AKAM | Akamai Technologies |
| AMD | Advanced Micro Devices |
| AMT | American Tower |
| AMZN | Amazon |
| ATVI | Activision Blizzard |
| BAX | Baxter International Inc |
In [10]:
stock_list = stockIndex.index.tolist()
if verbose: print('Stocks to process:', stock_list)
In [11]:
for ticker in stock_list:
iexcloud_url = "https://cloud.iexapis.com/stable/stock/%s/stats/sharesOutstanding?token=%s" % (ticker, iexcloud_key)
sleep(1)
response = requests.get(iexcloud_url)
share_data = json.loads(response.text)
stockIndex.loc[ticker,'Share_Outstanding'] = share_data
print('Company outstanding share number retrieved for', ticker, ':', share_data)
Company outstanding share number retrieved for AAPL : 4334340000 Company outstanding share number retrieved for ABBV : 1762340000 Company outstanding share number retrieved for ABT : 1768850000 Company outstanding share number retrieved for ADBE : 481801000 Company outstanding share number retrieved for AKAM : 162274000 Company outstanding share number retrieved for AMD : 1171190000 Company outstanding share number retrieved for AMT : 443306000 Company outstanding share number retrieved for AMZN : 498776000 Company outstanding share number retrieved for ATVI : 770486000 Company outstanding share number retrieved for BAX : 508836000 Company outstanding share number retrieved for BNTX : 228604644 Company outstanding share number retrieved for BSX : 1399350000 Company outstanding share number retrieved for BYND : 62236700 Company outstanding share number retrieved for CAG : 487076000 Company outstanding share number retrieved for CCI : 416751000 Company outstanding share number retrieved for CHGG : 123646000 Company outstanding share number retrieved for CHWY : 66479000 Company outstanding share number retrieved for CL : 856528000 Company outstanding share number retrieved for CLX : 125100000 Company outstanding share number retrieved for CMG : 27890700 Company outstanding share number retrieved for CNC : 579129000 Company outstanding share number retrieved for COR : 37903400 Company outstanding share number retrieved for COST : 441580000 Company outstanding share number retrieved for COUP : 66640900 Company outstanding share number retrieved for CPB : 301745000 Company outstanding share number retrieved for CRM : 899412000 Company outstanding share number retrieved for CRWD : 114945000 Company outstanding share number retrieved for CTXS : 123451000 Company outstanding share number retrieved for D : 839251000 Company outstanding share number retrieved for DDOG : 176048000 Company outstanding share number retrieved for DG : 251515000 Company outstanding share number retrieved for DHR : 707020000 Company outstanding share number retrieved for DOCU : 183127000 Company outstanding share number retrieved for DPZ : 39117900 Company outstanding share number retrieved for DXCM : 92300000 Company outstanding share number retrieved for EA : 288688000 Company outstanding share number retrieved for EBAY : 702679000 Company outstanding share number retrieved for EBS : 52427800 Company outstanding share number retrieved for EQIX : 88514500 Company outstanding share number retrieved for ETSY : 118678000 Company outstanding share number retrieved for EVBG : 34358100 Company outstanding share number retrieved for GILD : 1254000000 Company outstanding share number retrieved for GIS : 606139000 Company outstanding share number retrieved for GOLD : 1778040000 Company outstanding share number retrieved for GOOG : 336162000 Company outstanding share number retrieved for GSK : 2490337478 Company outstanding share number retrieved for HD : 1075520000 Company outstanding share number retrieved for HRL : 537776000 Company outstanding share number retrieved for JNJ : 2634590000 Company outstanding share number retrieved for K : 342670000 Company outstanding share number retrieved for KR : 786188000 Company outstanding share number retrieved for LLY : 957038000 Company outstanding share number retrieved for LOGI : 166897000 Company outstanding share number retrieved for LVGO : 97817000 Company outstanding share number retrieved for MASI : 54115400 Company outstanding share number retrieved for MDLZ : 1427460000 Company outstanding share number retrieved for MKC : 123641000 Company outstanding share number retrieved for MKTX : 37910200 Company outstanding share number retrieved for MRNA : 371224000 Company outstanding share number retrieved for MRVL : 663100000 Company outstanding share number retrieved for MSFT : 7583440000 Company outstanding share number retrieved for NET : 165000000 Company outstanding share number retrieved for NFLX : 439804000 Company outstanding share number retrieved for NVDA : 615135000 Company outstanding share number retrieved for OKTA : 116101000 Company outstanding share number retrieved for PANW : 96465900 Company outstanding share number retrieved for PEP : 1387500000 Company outstanding share number retrieved for PFE : 5554830000 Company outstanding share number retrieved for PG : 2475640000 Company outstanding share number retrieved for PLD : 738582000 Company outstanding share number retrieved for PRGO : 136313000 Company outstanding share number retrieved for PTON : 206067000 Company outstanding share number retrieved for PYPL : 1174160000 Company outstanding share number retrieved for REGN : 110673000 Company outstanding share number retrieved for RMD : 144668000 Company outstanding share number retrieved for RNG : 77005900 Company outstanding share number retrieved for SHOP : 107511000 Company outstanding share number retrieved for SJM : 114038000 Company outstanding share number retrieved for SNY : 2508821038 Company outstanding share number retrieved for SPGI : 240900000 Company outstanding share number retrieved for SPLK : 158796000 Company outstanding share number retrieved for SPOT : 182788290 Company outstanding share number retrieved for SQ : 362988000 Company outstanding share number retrieved for TDOC : 74453300 Company outstanding share number retrieved for TGT : 499920000 Company outstanding share number retrieved for TMO : 394951000 Company outstanding share number retrieved for TTD : 40888700 Company outstanding share number retrieved for TTWO : 113943000 Company outstanding share number retrieved for TW : 83945500 Company outstanding share number retrieved for TWLO : 128614000 Company outstanding share number retrieved for UNH : 948380000 Company outstanding share number retrieved for VEEV : 134844000 Company outstanding share number retrieved for VZ : 4138000000 Company outstanding share number retrieved for WING : 29583000 Company outstanding share number retrieved for WIX : 51526000 Company outstanding share number retrieved for WMT : 2833700000 Company outstanding share number retrieved for WORK : 425484000 Company outstanding share number retrieved for ZM : 167557000 Company outstanding share number retrieved for ZS : 129352000 Company outstanding share number retrieved for ZTS : 474941000
In [12]:
stockIndex.head(10)
Out[12]:
| Name | Share_Outstanding | |
|---|---|---|
| Symbol | ||
| AAPL | Apple | 4.334340e+09 |
| ABBV | AbbVie | 1.762340e+09 |
| ABT | Abbott Labs | 1.768850e+09 |
| ADBE | Adobe | 4.818010e+08 |
| AKAM | Akamai Technologies | 1.622740e+08 |
| AMD | Advanced Micro Devices | 1.171190e+09 |
| AMT | American Tower | 4.433060e+08 |
| AMZN | Amazon | 4.987760e+08 |
| ATVI | Activision Blizzard | 7.704860e+08 |
| BAX | Baxter International Inc | 5.088360e+08 |
In [13]:
total_shares = stockIndex['Share_Outstanding'].sum()
In [14]:
# Create the master dataframe to hold the index and individual stock data
date_index = pd.date_range(start=stock_start_date, end=model_end_date)
columns = ['JC_MAD']
index_df = pd.DataFrame(index=date_index, columns=columns)
index_df = index_df.fillna(0.0)
index_df.head()
Out[14]:
| JC_MAD | |
|---|---|
| 2018-10-18 | 0.0 |
| 2018-10-19 | 0.0 |
| 2018-10-20 | 0.0 |
| 2018-10-21 | 0.0 |
| 2018-10-22 | 0.0 |
In [15]:
# Create the master dataframe to hold the index and individual stock data
stock_df = pd.DataFrame(index=date_index)
stock_df.head()
Out[15]:
| 2018-10-18 |
|---|
| 2018-10-19 |
| 2018-10-20 |
| 2018-10-21 |
| 2018-10-22 |
In [16]:
start_date_string = stock_start_date.strftime('%Y-%m-%d')
end_date_string = model_end_date.strftime('%Y-%m-%d')
for ticker in stock_list:
quandl_url = "https://www.quandl.com/api/v3/datatables/SHARADAR/SEP.json?date.gte=%s&date.lte=%s&ticker=%s&api_key=%s" % (start_date_string, end_date_string, ticker, quandl_key)
response = requests.get(quandl_url)
sleep(1)
quandl_dict = json.loads(response.text)
stock_data = pd.DataFrame(quandl_dict['datatable']['data'])
print(len(stock_data), 'data points retrieved from the API call for:', ticker)
stock_data.columns = ['ticker', 'date', 'open', 'high', 'low', 'close', 'volume', 'dividend', 'closeunadj', 'lastupdated']
stock_data.index = pd.to_datetime(stock_data.date)
stock_data = stock_data.sort_index(ascending = True)
stock_close = stock_data.loc[:, ['closeunadj']]
stock_close.rename(columns={'closeunadj': ticker}, inplace=True)
stock_df = pd.concat([stock_df, stock_close], axis=1)
component_close = stock_data.loc[:, ['closeunadj']] * stockIndex.loc[ticker, 'Share_Outstanding'] / total_shares
component_close.rename(columns={'closeunadj': ticker}, inplace=True)
index_df = pd.concat([index_df, component_close], axis=1)
index_df.dropna(inplace=True)
index_df['JC_MAD'] = index_df[stock_list].sum(axis=1)
405 data points retrieved from the API call for: AAPL 405 data points retrieved from the API call for: ABBV 405 data points retrieved from the API call for: ABT 405 data points retrieved from the API call for: ADBE 405 data points retrieved from the API call for: AKAM 405 data points retrieved from the API call for: AMD 405 data points retrieved from the API call for: AMT 405 data points retrieved from the API call for: AMZN 405 data points retrieved from the API call for: ATVI 405 data points retrieved from the API call for: BAX 160 data points retrieved from the API call for: BNTX 405 data points retrieved from the API call for: BSX 272 data points retrieved from the API call for: BYND 405 data points retrieved from the API call for: CAG 405 data points retrieved from the API call for: CCI 405 data points retrieved from the API call for: CHGG 242 data points retrieved from the API call for: CHWY 405 data points retrieved from the API call for: CL 405 data points retrieved from the API call for: CLX 405 data points retrieved from the API call for: CMG 405 data points retrieved from the API call for: CNC 405 data points retrieved from the API call for: COR 405 data points retrieved from the API call for: COST 405 data points retrieved from the API call for: COUP 405 data points retrieved from the API call for: CPB 405 data points retrieved from the API call for: CRM 243 data points retrieved from the API call for: CRWD 405 data points retrieved from the API call for: CTXS 405 data points retrieved from the API call for: D 175 data points retrieved from the API call for: DDOG 405 data points retrieved from the API call for: DG 405 data points retrieved from the API call for: DHR 405 data points retrieved from the API call for: DOCU 405 data points retrieved from the API call for: DPZ 405 data points retrieved from the API call for: DXCM 405 data points retrieved from the API call for: EA 405 data points retrieved from the API call for: EBAY 405 data points retrieved from the API call for: EBS 405 data points retrieved from the API call for: EQIX 405 data points retrieved from the API call for: ETSY 405 data points retrieved from the API call for: EVBG 405 data points retrieved from the API call for: GILD 405 data points retrieved from the API call for: GIS 405 data points retrieved from the API call for: GOLD 405 data points retrieved from the API call for: GOOG 405 data points retrieved from the API call for: GSK 405 data points retrieved from the API call for: HD 405 data points retrieved from the API call for: HRL 405 data points retrieved from the API call for: JNJ 405 data points retrieved from the API call for: K 405 data points retrieved from the API call for: KR 405 data points retrieved from the API call for: LLY 405 data points retrieved from the API call for: LOGI 214 data points retrieved from the API call for: LVGO 405 data points retrieved from the API call for: MASI 405 data points retrieved from the API call for: MDLZ 405 data points retrieved from the API call for: MKC 405 data points retrieved from the API call for: MKTX 371 data points retrieved from the API call for: MRNA 405 data points retrieved from the API call for: MRVL 405 data points retrieved from the API call for: MSFT 179 data points retrieved from the API call for: NET 405 data points retrieved from the API call for: NFLX 405 data points retrieved from the API call for: NVDA 405 data points retrieved from the API call for: OKTA 405 data points retrieved from the API call for: PANW 405 data points retrieved from the API call for: PEP 405 data points retrieved from the API call for: PFE 405 data points retrieved from the API call for: PG 405 data points retrieved from the API call for: PLD 405 data points retrieved from the API call for: PRGO 170 data points retrieved from the API call for: PTON 405 data points retrieved from the API call for: PYPL 405 data points retrieved from the API call for: REGN 405 data points retrieved from the API call for: RMD 405 data points retrieved from the API call for: RNG 405 data points retrieved from the API call for: SHOP 405 data points retrieved from the API call for: SJM 405 data points retrieved from the API call for: SNY 405 data points retrieved from the API call for: SPGI 405 data points retrieved from the API call for: SPLK 405 data points retrieved from the API call for: SPOT 405 data points retrieved from the API call for: SQ 405 data points retrieved from the API call for: TDOC 405 data points retrieved from the API call for: TGT 405 data points retrieved from the API call for: TMO 405 data points retrieved from the API call for: TTD 405 data points retrieved from the API call for: TTWO 291 data points retrieved from the API call for: TW 405 data points retrieved from the API call for: TWLO 405 data points retrieved from the API call for: UNH 405 data points retrieved from the API call for: VEEV 405 data points retrieved from the API call for: VZ 405 data points retrieved from the API call for: WING 405 data points retrieved from the API call for: WIX 405 data points retrieved from the API call for: WMT 238 data points retrieved from the API call for: WORK 281 data points retrieved from the API call for: ZM 405 data points retrieved from the API call for: ZS 405 data points retrieved from the API call for: ZTS
In [17]:
stock_df.head()
Out[17]:
| AAPL | ABBV | ABT | ADBE | AKAM | AMD | AMT | AMZN | ATVI | BAX | ... | UNH | VEEV | VZ | WING | WIX | WMT | WORK | ZM | ZS | ZTS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2018-10-18 | 216.02 | 89.90 | 68.14 | 250.35 | 64.50 | 26.62 | 146.79 | 1770.72 | 71.81 | 70.47 | ... | 266.81 | 93.50 | 54.65 | 71.36 | 97.45 | 96.17 | NaN | NaN | 36.78 | 91.83 |
| 2018-10-19 | 219.31 | 87.97 | 67.59 | 245.03 | 64.24 | 23.66 | 150.15 | 1764.03 | 69.75 | 69.46 | ... | 265.30 | 91.63 | 54.90 | 70.79 | 95.00 | 97.15 | NaN | NaN | 35.68 | 91.47 |
| 2018-10-20 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 2018-10-21 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 2018-10-22 | 220.65 | 84.27 | 68.52 | 251.06 | 65.18 | 25.03 | 149.25 | 1789.30 | 69.78 | 69.02 | ... | 262.19 | 91.62 | 54.98 | 70.16 | 97.98 | 97.14 | NaN | NaN | 36.30 | 92.80 |
5 rows × 100 columns
In [18]:
stock_df.tail()
Out[18]:
| AAPL | ABBV | ABT | ADBE | AKAM | AMD | AMT | AMZN | ATVI | BAX | ... | UNH | VEEV | VZ | WING | WIX | WMT | WORK | ZM | ZS | ZTS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2020-05-25 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 2020-05-26 | 316.73 | 90.71 | 89.48 | 376.63 | 100.08 | 53.19 | 243.93 | 2421.86 | 70.00 | 85.51 | ... | 294.89 | 195.12 | 54.30 | 118.99 | 209.76 | 123.86 | 32.41 | 164.00 | 76.52 | 130.45 |
| 2020-05-27 | 318.11 | 89.98 | 90.76 | 375.17 | 99.97 | 52.74 | 252.01 | 2410.39 | 70.15 | 86.44 | ... | 303.77 | 191.99 | 55.14 | 119.86 | 205.96 | 122.48 | 32.11 | 161.97 | 74.53 | 135.64 |
| 2020-05-28 | 318.25 | 90.03 | 92.10 | 379.83 | 102.91 | 51.74 | 258.12 | 2401.10 | 70.22 | 88.20 | ... | 303.97 | 204.20 | 55.72 | 119.07 | 207.40 | 123.69 | 32.54 | 163.55 | 75.80 | 138.11 |
| 2020-05-29 | 317.94 | 92.67 | 94.92 | 386.60 | 105.80 | 53.80 | 258.17 | 2442.37 | 71.98 | 90.01 | ... | 304.85 | 218.87 | 57.38 | 121.95 | 222.33 | 124.06 | 35.05 | 179.48 | 98.09 | 139.39 |
5 rows × 100 columns
In [19]:
index_df.head()
Out[19]:
| JC_MAD | AAPL | ABBV | ABT | ADBE | AKAM | AMD | AMT | AMZN | ATVI | ... | UNH | VEEV | VZ | WING | WIX | WMT | WORK | ZM | ZS | ZTS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2019-10-10 | 119.108355 | 13.672285 | 1.798766 | 1.943393 | 1.816307 | 0.198798 | 0.455680 | 1.375214 | 11.763052 | 0.567125 | ... | 2.908888 | 0.277832 | 3.394141 | 0.035771 | 0.088123 | 4.646669 | 0.138946 | 0.163118 | 0.083879 | 0.829590 |
| 2019-10-11 | 119.983371 | 14.035945 | 1.778955 | 1.931026 | 1.838170 | 0.199221 | 0.477677 | 1.364092 | 11.842783 | 0.579061 | ... | 2.887305 | 0.281067 | 3.399814 | 0.035954 | 0.088914 | 4.671144 | 0.151604 | 0.163899 | 0.085333 | 0.836492 |
| 2019-10-14 | 119.830417 | 14.015741 | 1.782096 | 1.935633 | 1.834801 | 0.199866 | 0.490201 | 1.371324 | 11.873622 | 0.581068 | ... | 2.868062 | 0.283267 | 3.381093 | 0.035893 | 0.088772 | 4.629576 | 0.143612 | 0.162636 | 0.084234 | 0.824251 |
| 2019-10-15 | 121.034640 | 13.983059 | 1.799975 | 1.988013 | 1.845436 | 0.203181 | 0.493252 | 1.362633 | 12.085257 | 0.586877 | ... | 3.102094 | 0.289256 | 3.434986 | 0.035860 | 0.088222 | 4.643561 | 0.144312 | 0.163348 | 0.082257 | 0.838055 |
| 2019-10-16 | 120.604866 | 13.926609 | 1.806015 | 1.983163 | 1.801247 | 0.202291 | 0.494697 | 1.349020 | 12.153978 | 0.587194 | ... | 3.081292 | 0.277074 | 3.420237 | 0.036104 | 0.086964 | 4.639288 | 0.137896 | 0.155492 | 0.080953 | 0.832976 |
5 rows × 101 columns
In [20]:
index_df.tail()
Out[20]:
| JC_MAD | AAPL | ABBV | ABT | ADBE | AKAM | AMD | AMT | AMZN | ATVI | ... | UNH | VEEV | VZ | WING | WIX | WMT | WORK | ZM | ZS | ZTS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2020-05-22 | 148.924160 | 18.948911 | 2.225203 | 2.218146 | 2.544732 | 0.223403 | 0.885831 | 1.473365 | 16.663264 | 0.771940 | ... | 3.769736 | 0.375200 | 3.069080 | 0.049163 | 0.152023 | 4.830034 | 0.184969 | 0.392945 | 0.136441 | 0.847170 |
| 2020-05-26 | 147.511579 | 18.820561 | 2.191620 | 2.169888 | 2.487729 | 0.222647 | 0.854039 | 1.482481 | 16.560558 | 0.739406 | ... | 3.834095 | 0.360706 | 3.080425 | 0.048258 | 0.148173 | 4.811775 | 0.189053 | 0.376727 | 0.135696 | 0.849384 |
| 2020-05-27 | 147.959211 | 18.902563 | 2.173983 | 2.200928 | 2.478085 | 0.222402 | 0.846814 | 1.531587 | 16.482127 | 0.740991 | ... | 3.949550 | 0.354920 | 3.128078 | 0.048611 | 0.145489 | 4.758164 | 0.187303 | 0.372064 | 0.132167 | 0.883177 |
| 2020-05-28 | 148.842406 | 18.910882 | 2.175191 | 2.233423 | 2.508865 | 0.228943 | 0.830757 | 1.568721 | 16.418602 | 0.741730 | ... | 3.952151 | 0.377492 | 3.160982 | 0.048291 | 0.146506 | 4.805171 | 0.189811 | 0.375693 | 0.134420 | 0.899260 |
| 2020-05-29 | 150.886399 | 18.892461 | 2.238975 | 2.301808 | 2.553583 | 0.235372 | 0.863833 | 1.569025 | 16.700805 | 0.760321 | ... | 3.963592 | 0.404612 | 3.255153 | 0.049459 | 0.157053 | 4.819545 | 0.204452 | 0.412286 | 0.173948 | 0.907594 |
5 rows × 101 columns
In [21]:
title_string = 'Historical Pricing for the Cramer COVID-19 Index'
index_df['JC_MAD'].plot(figsize=(16,9), title=title_string)
plt.show()
In [22]:
if notifyStatus: email_notify("Task 2. Acquire and Pre-Process Data completed! "+datetime.now().strftime('%a %B %d, %Y %I:%M:%S %p'))
Task 3. Develop Strategy and Train Model¶
In [23]:
if notifyStatus: email_notify("Task 3. Develop Strategy and Train Model has begun! "+datetime.now().strftime('%a %B %d, %Y %I:%M:%S %p'))
In [24]:
def ma_crossover(data):
wait_for_entry = True
for x in range(len(data)):
if data['ma_change'].iloc[x] > 0:
data['signal'].iloc[x] = 1 # Signal = 1 means we should take a long position
else:
data['signal'].iloc[x] = 0 # Signal = 0 means we should not have a position
if x != 0:
data['signal_chg'].iloc[x] = data['signal'].iloc[x] - data['signal'].iloc[x-1]
if wait_for_entry and (data['signal_chg'].iloc[x-1] == 1):
data['entry_exit'].iloc[x] = data['signal_chg'].iloc[x-1]
wait_for_entry = False
elif (not wait_for_entry) and (data['signal_chg'].iloc[x-1] != 0):
data['entry_exit'].iloc[x] = data['signal_chg'].iloc[x-1]
In [25]:
dataframe_collection = {}
for ticker in stock_list:
print('Processing dataframe for ticker symbol:', ticker)
dataframe_collection[ticker] = pd.DataFrame(stock_df[ticker])
dataframe_collection[ticker].dropna(inplace=True)
dataframe_collection[ticker].rename(columns={ticker: 'close'}, inplace=True)
dataframe_collection[ticker]['fast_ma'] = dataframe_collection[ticker]['close'].rolling(fast_ma).mean()
dataframe_collection[ticker]['slow_ma'] = dataframe_collection[ticker]['close'].rolling(slow_ma).mean()
dataframe_collection[ticker]['ma_change'] = dataframe_collection[ticker]['fast_ma'] - dataframe_collection[ticker]['slow_ma']
dataframe_collection[ticker]['signal'] = np.zeros(len(dataframe_collection[ticker]))
dataframe_collection[ticker]['signal_chg'] = np.zeros(len(dataframe_collection[ticker]))
dataframe_collection[ticker]['entry_exit'] = np.zeros(len(dataframe_collection[ticker]))
dataframe_collection[ticker] = dataframe_collection[ticker][model_start_date:model_end_date]
ma_crossover(dataframe_collection[ticker])
Processing dataframe for ticker symbol: AAPL Processing dataframe for ticker symbol: ABBV Processing dataframe for ticker symbol: ABT Processing dataframe for ticker symbol: ADBE Processing dataframe for ticker symbol: AKAM Processing dataframe for ticker symbol: AMD Processing dataframe for ticker symbol: AMT Processing dataframe for ticker symbol: AMZN Processing dataframe for ticker symbol: ATVI Processing dataframe for ticker symbol: BAX Processing dataframe for ticker symbol: BNTX Processing dataframe for ticker symbol: BSX Processing dataframe for ticker symbol: BYND Processing dataframe for ticker symbol: CAG Processing dataframe for ticker symbol: CCI Processing dataframe for ticker symbol: CHGG Processing dataframe for ticker symbol: CHWY Processing dataframe for ticker symbol: CL Processing dataframe for ticker symbol: CLX Processing dataframe for ticker symbol: CMG Processing dataframe for ticker symbol: CNC Processing dataframe for ticker symbol: COR Processing dataframe for ticker symbol: COST Processing dataframe for ticker symbol: COUP Processing dataframe for ticker symbol: CPB Processing dataframe for ticker symbol: CRM Processing dataframe for ticker symbol: CRWD Processing dataframe for ticker symbol: CTXS Processing dataframe for ticker symbol: D Processing dataframe for ticker symbol: DDOG Processing dataframe for ticker symbol: DG Processing dataframe for ticker symbol: DHR Processing dataframe for ticker symbol: DOCU Processing dataframe for ticker symbol: DPZ Processing dataframe for ticker symbol: DXCM Processing dataframe for ticker symbol: EA Processing dataframe for ticker symbol: EBAY Processing dataframe for ticker symbol: EBS Processing dataframe for ticker symbol: EQIX Processing dataframe for ticker symbol: ETSY Processing dataframe for ticker symbol: EVBG Processing dataframe for ticker symbol: GILD Processing dataframe for ticker symbol: GIS Processing dataframe for ticker symbol: GOLD Processing dataframe for ticker symbol: GOOG Processing dataframe for ticker symbol: GSK Processing dataframe for ticker symbol: HD Processing dataframe for ticker symbol: HRL Processing dataframe for ticker symbol: JNJ Processing dataframe for ticker symbol: K Processing dataframe for ticker symbol: KR Processing dataframe for ticker symbol: LLY Processing dataframe for ticker symbol: LOGI Processing dataframe for ticker symbol: LVGO Processing dataframe for ticker symbol: MASI Processing dataframe for ticker symbol: MDLZ Processing dataframe for ticker symbol: MKC Processing dataframe for ticker symbol: MKTX Processing dataframe for ticker symbol: MRNA Processing dataframe for ticker symbol: MRVL Processing dataframe for ticker symbol: MSFT Processing dataframe for ticker symbol: NET Processing dataframe for ticker symbol: NFLX Processing dataframe for ticker symbol: NVDA Processing dataframe for ticker symbol: OKTA Processing dataframe for ticker symbol: PANW Processing dataframe for ticker symbol: PEP Processing dataframe for ticker symbol: PFE Processing dataframe for ticker symbol: PG Processing dataframe for ticker symbol: PLD Processing dataframe for ticker symbol: PRGO Processing dataframe for ticker symbol: PTON Processing dataframe for ticker symbol: PYPL Processing dataframe for ticker symbol: REGN Processing dataframe for ticker symbol: RMD Processing dataframe for ticker symbol: RNG Processing dataframe for ticker symbol: SHOP Processing dataframe for ticker symbol: SJM Processing dataframe for ticker symbol: SNY Processing dataframe for ticker symbol: SPGI Processing dataframe for ticker symbol: SPLK Processing dataframe for ticker symbol: SPOT Processing dataframe for ticker symbol: SQ Processing dataframe for ticker symbol: TDOC Processing dataframe for ticker symbol: TGT Processing dataframe for ticker symbol: TMO Processing dataframe for ticker symbol: TTD Processing dataframe for ticker symbol: TTWO Processing dataframe for ticker symbol: TW Processing dataframe for ticker symbol: TWLO Processing dataframe for ticker symbol: UNH Processing dataframe for ticker symbol: VEEV Processing dataframe for ticker symbol: VZ Processing dataframe for ticker symbol: WING Processing dataframe for ticker symbol: WIX Processing dataframe for ticker symbol: WMT Processing dataframe for ticker symbol: WORK Processing dataframe for ticker symbol: ZM Processing dataframe for ticker symbol: ZS Processing dataframe for ticker symbol: ZTS
In [26]:
for ticker in stock_list:
print('List the signal change and entry/exit points for', ticker)
print(dataframe_collection[ticker][(dataframe_collection[ticker].signal_chg != 0) | (dataframe_collection[ticker].entry_exit != 0)])
print()
List the signal change and entry/exit points for AAPL
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-02-12 170.89 162.4450 161.6908 0.7542 1.0 1.0 0.0
2019-02-13 170.18 163.3005 161.5034 1.7971 1.0 0.0 1.0
2019-05-24 178.97 195.2160 195.7504 -0.5344 0.0 -1.0 0.0
2019-05-28 178.23 193.8970 195.5926 -1.6956 0.0 0.0 -1.0
2019-07-01 201.55 194.3815 194.0596 0.3219 1.0 1.0 0.0
2019-07-02 202.73 195.5360 194.0236 1.5124 1.0 0.0 1.0
2020-03-05 292.92 307.4485 307.6264 -0.1779 0.0 -1.0 0.0
2020-03-06 289.03 305.6395 307.7270 -2.0875 0.0 0.0 -1.0
2020-04-30 293.80 273.9600 271.0604 2.8996 1.0 1.0 0.0
2020-05-01 289.07 276.1670 270.4358 5.7312 1.0 0.0 1.0
List the signal change and entry/exit points for ABBV
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-14 84.76 87.4590 87.4878 -0.0288 0.0 -1.0 0.0
2019-01-23 88.45 88.3055 88.1686 0.1369 1.0 1.0 0.0
2019-01-24 85.88 88.3915 88.1316 0.2599 1.0 0.0 1.0
2019-01-25 80.54 87.9665 87.9666 -0.0001 0.0 -1.0 0.0
2019-01-28 77.14 87.3280 87.7156 -0.3876 0.0 0.0 -1.0
2019-04-03 83.08 80.1700 80.1204 0.0496 1.0 1.0 0.0
2019-04-04 82.81 80.3985 80.0076 0.3909 1.0 0.0 1.0
2019-05-06 79.26 79.9250 80.0834 -0.1584 0.0 -1.0 0.0
2019-05-07 77.95 79.6235 80.0366 -0.4131 0.0 0.0 -1.0
2019-09-16 70.58 67.3440 67.2546 0.0894 1.0 1.0 0.0
2019-09-17 71.60 67.5960 67.2622 0.3338 1.0 0.0 1.0
2020-01-28 83.77 87.8715 87.9786 -0.1071 0.0 -1.0 0.0
2020-01-29 83.20 87.6055 87.8900 -0.2845 0.0 0.0 -1.0
2020-02-21 94.96 89.2485 88.9386 0.3099 1.0 1.0 0.0
2020-02-24 93.14 89.7285 89.0702 0.6583 1.0 0.0 1.0
2020-03-16 74.27 88.1070 88.1932 -0.0862 0.0 -1.0 0.0
2020-03-17 73.02 87.0775 87.8796 -0.8021 0.0 0.0 -1.0
2020-05-01 82.84 81.0030 80.6106 0.3924 1.0 1.0 0.0
2020-05-04 81.86 81.4275 80.3486 1.0789 1.0 0.0 1.0
List the signal change and entry/exit points for ABT
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-03 66.22 70.03250 70.0986 -0.06610 0.0 -1.0 0.0
2019-02-04 72.50 70.37250 70.2968 0.07570 1.0 1.0 0.0
2019-02-05 73.11 70.57150 70.3778 0.19370 1.0 0.0 1.0
2019-04-26 78.56 77.68650 77.7090 -0.02250 0.0 -1.0 0.0
2019-04-29 78.27 77.60300 77.7950 -0.19200 0.0 0.0 -1.0
2019-06-12 81.95 77.54050 77.5116 0.02890 1.0 1.0 0.0
2019-06-13 82.29 77.82950 77.5650 0.26450 1.0 0.0 1.0
2019-08-26 83.12 85.03575 85.2753 -0.23955 0.0 -1.0 0.0
2019-08-27 83.65 84.80275 85.3073 -0.50455 0.0 0.0 -1.0
2019-11-12 84.34 82.63600 82.5876 0.04840 1.0 1.0 0.0
2019-11-13 84.22 82.75800 82.5876 0.17040 1.0 0.0 1.0
2020-02-27 79.19 87.17750 87.4096 -0.23210 0.0 -1.0 0.0
2020-02-28 77.03 86.57100 87.2222 -0.65120 0.0 0.0 -1.0
2020-04-21 94.05 83.50800 82.1262 1.38180 1.0 1.0 0.0
2020-04-22 95.48 84.79750 82.2698 2.52770 1.0 0.0 1.0
List the signal change and entry/exit points for ADBE
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-25 244.95 235.04700 234.5062 0.54080 1.0 1.0 0.0
2019-01-28 241.85 235.88250 234.6098 1.27270 1.0 0.0 1.0
2019-06-07 278.16 274.66100 274.6686 -0.00760 0.0 -1.0 0.0
2019-06-10 280.34 274.75400 275.0048 -0.25080 0.0 0.0 -1.0
2019-06-12 276.84 275.41750 275.2882 0.12930 1.0 1.0 0.0
2019-06-13 276.30 275.39150 275.3872 0.00430 1.0 0.0 1.0
2019-06-14 274.28 274.92800 275.4428 -0.51480 0.0 -1.0 0.0
2019-06-17 275.60 274.71550 275.5970 -0.88150 0.0 0.0 -1.0
2019-06-21 299.33 277.70750 277.4490 0.25850 1.0 1.0 0.0
2019-06-24 299.87 278.96250 278.0084 0.95410 1.0 0.0 1.0
2019-08-19 287.97 295.59150 295.9512 -0.35970 0.0 -1.0 0.0
2019-08-20 285.71 294.48300 296.0586 -1.57560 0.0 0.0 -1.0
2019-11-13 293.54 277.73000 277.6440 0.08600 1.0 1.0 0.0
2019-11-14 294.53 278.99450 277.7796 1.21490 1.0 0.0 1.0
2020-03-12 285.00 350.32050 350.3536 -0.03310 0.0 -1.0 0.0
2020-03-13 335.50 348.35350 350.4674 -2.11390 0.0 0.0 -1.0
2020-04-30 353.64 330.85775 328.5449 2.31285 1.0 1.0 0.0
2020-05-01 343.84 332.85175 327.8425 5.00925 1.0 0.0 1.0
List the signal change and entry/exit points for AKAM
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-02-06 67.51 64.8065 64.6520 0.1545 1.0 1.0 0.0
2019-02-07 66.59 64.9730 64.6280 0.3450 1.0 0.0 1.0
2019-10-31 86.50 89.6980 89.7560 -0.0580 0.0 -1.0 0.0
2019-11-01 87.50 89.5275 89.7316 -0.2041 0.0 0.0 -1.0
2020-01-09 93.19 86.5950 86.5788 0.0162 1.0 1.0 0.0
2020-01-10 93.53 87.0790 86.6916 0.3874 1.0 0.0 1.0
2020-03-12 80.05 92.9755 93.4671 -0.4916 0.0 -1.0 0.0
2020-03-13 85.73 92.2820 93.4541 -1.1721 0.0 0.0 -1.0
2020-04-15 100.39 93.2900 93.1304 0.1596 1.0 1.0 0.0
2020-04-16 105.84 93.7270 93.3428 0.3842 1.0 0.0 1.0
List the signal change and entry/exit points for AMD
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-28 20.18 19.8280 19.7992 0.0288 1.0 1.0 0.0
2019-01-29 19.25 19.8995 19.7920 0.1075 1.0 0.0 1.0
2019-06-03 27.58 27.3685 27.3906 -0.0221 0.0 -1.0 0.0
2019-06-04 29.57 27.4760 27.4546 0.0214 1.0 1.0 -1.0
2019-06-05 29.50 27.6180 27.5252 0.0928 1.0 0.0 1.0
2019-08-20 30.72 31.5440 31.5940 -0.0500 0.0 -1.0 0.0
2019-08-21 31.70 31.4235 31.5798 -0.1563 0.0 0.0 -1.0
2019-10-29 33.03 30.4985 30.4302 0.0683 1.0 1.0 0.0
2019-10-30 33.13 30.7395 30.4784 0.2611 1.0 0.0 1.0
2020-03-12 39.01 49.2115 49.3905 -0.1790 0.0 -1.0 0.0
2020-03-13 43.90 48.6800 49.3513 -0.6713 0.0 0.0 -1.0
2020-04-20 56.97 48.7140 48.2246 0.4894 1.0 1.0 0.0
2020-04-21 52.92 49.2780 48.2884 0.9896 1.0 0.0 1.0
List the signal change and entry/exit points for AMT
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-10 161.86 160.2380 160.6698 -0.4318 0.0 -1.0 0.0
2019-01-29 169.44 162.6270 162.5576 0.0694 1.0 1.0 0.0
2019-01-30 170.47 163.2410 162.6988 0.5422 1.0 0.0 1.0
2019-07-25 205.42 207.7075 207.8704 -0.1629 0.0 -1.0 0.0
2019-07-26 204.59 207.6445 207.9528 -0.3083 0.0 0.0 -1.0
2019-08-09 222.23 210.7760 210.5212 0.2548 1.0 1.0 0.0
2019-08-12 222.30 211.3560 210.7918 0.5642 1.0 0.0 1.0
2019-10-03 223.90 221.6250 221.8928 -0.2678 0.0 -1.0 0.0
2019-10-04 225.93 221.2920 222.3030 -1.0110 0.0 0.0 -1.0
2019-12-26 227.87 216.2285 215.6750 0.5535 1.0 1.0 0.0
2019-12-27 229.08 216.9370 215.8172 1.1198 1.0 0.0 1.0
2020-03-18 217.14 236.4695 237.6282 -1.1587 0.0 -1.0 0.0
2020-03-19 209.00 234.5425 237.3346 -2.7921 0.0 0.0 -1.0
2020-04-22 252.98 235.6220 234.8042 0.8178 1.0 1.0 0.0
2020-04-23 248.60 238.0890 234.6908 3.3982 1.0 0.0 1.0
List the signal change and entry/exit points for AMZN
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-24 1654.93 1603.0855 1596.0338 7.0517 1.0 1.0 0.0
2019-01-25 1670.57 1613.0690 1595.1966 17.8724 1.0 0.0 1.0
2019-06-03 1692.69 1852.2160 1853.0406 -0.8246 0.0 -1.0 0.0
2019-06-04 1729.56 1841.1665 1852.3364 -11.1699 0.0 0.0 -1.0
2019-07-02 1934.31 1874.3300 1871.5726 2.7574 1.0 1.0 0.0
2019-07-03 1939.00 1884.3550 1871.8772 12.4778 1.0 0.0 1.0
2019-08-13 1824.34 1889.2330 1897.6744 -8.4414 0.0 -1.0 0.0
2019-08-14 1762.96 1877.7795 1898.3424 -20.5629 0.0 0.0 -1.0
2019-11-08 1785.88 1777.3000 1776.6000 0.7000 1.0 1.0 0.0
2019-11-11 1771.65 1779.0610 1776.5072 2.5538 1.0 0.0 1.0
2019-12-11 1748.72 1760.5170 1761.9126 -1.3956 0.0 -1.0 0.0
2019-12-12 1760.33 1760.8780 1762.8546 -1.9766 0.0 0.0 -1.0
2019-12-19 1792.28 1768.4870 1768.3124 0.1746 1.0 1.0 0.0
2019-12-20 1786.50 1771.0765 1769.6372 1.4393 1.0 0.0 1.0
2020-03-16 1689.15 1931.6285 1945.1250 -13.4965 0.0 -1.0 0.0
2020-03-17 1807.84 1914.2370 1943.7824 -29.5454 0.0 0.0 -1.0
2020-04-15 2307.68 1982.1495 1980.6380 1.5115 1.0 1.0 0.0
2020-04-16 2408.19 2011.0590 1987.8084 23.2506 1.0 0.0 1.0
List the signal change and entry/exit points for ATVI
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-04-01 47.12 44.76550 44.5754 0.19010 1.0 1.0 0.0
2019-04-02 47.46 45.04450 44.5516 0.49290 1.0 0.0 1.0
2019-05-23 42.19 46.22850 46.3220 -0.09350 0.0 -1.0 0.0
2019-05-24 42.29 45.93550 46.3014 -0.36590 0.0 0.0 -1.0
2019-07-01 47.50 45.84350 45.7308 0.11270 1.0 1.0 0.0
2019-07-02 47.98 46.06200 45.7836 0.27840 1.0 0.0 1.0
2019-11-14 52.70 54.61550 54.6176 -0.00210 0.0 -1.0 0.0
2019-11-15 53.44 54.56050 54.5948 -0.03430 0.0 0.0 -1.0
2019-12-13 58.65 54.71975 54.7075 0.01225 1.0 1.0 0.0
2019-12-16 58.61 54.97825 54.7709 0.20735 1.0 0.0 1.0
2020-03-16 52.76 60.01325 60.1392 -0.12595 0.0 -1.0 0.0
2020-03-17 56.16 59.63425 60.0890 -0.45475 0.0 0.0 -1.0
2020-04-20 66.50 60.54150 60.0457 0.49580 1.0 1.0 0.0
2020-04-21 65.72 61.00400 60.1295 0.87450 1.0 0.0 1.0
List the signal change and entry/exit points for BAX
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-16 68.26 65.4255 65.3808 0.0447 1.0 1.0 0.0
2019-01-17 69.12 65.6260 65.5196 0.1064 1.0 0.0 1.0
2019-05-06 77.32 77.1730 77.2704 -0.0974 0.0 -1.0 0.0
2019-05-07 76.69 77.0245 77.3084 -0.2839 0.0 0.0 -1.0
2019-06-19 81.31 76.6885 76.6730 0.0155 1.0 1.0 0.0
2019-06-20 82.04 77.0120 76.7124 0.2996 1.0 0.0 1.0
2019-10-15 87.74 86.6910 86.7218 -0.0308 0.0 -1.0 0.0
2019-10-16 87.02 86.6700 86.7940 -0.1240 0.0 0.0 -1.0
2019-12-17 83.25 82.4400 82.2896 0.1504 1.0 1.0 0.0
2019-12-18 83.66 82.5395 82.2626 0.2769 1.0 0.0 1.0
2020-03-10 82.98 88.4975 88.6696 -0.1721 0.0 -1.0 0.0
2020-03-11 77.97 87.8035 88.5480 -0.7445 0.0 0.0 -1.0
2020-04-22 90.54 84.8710 84.7622 0.1088 1.0 1.0 0.0
2020-04-23 91.32 85.7585 84.7516 1.0069 1.0 0.0 1.0
List the signal change and entry/exit points for BNTX
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-12-19 29.34 26.2345 20.7948 5.4397 1.0 1.0 0.0
2019-12-20 34.97 26.9990 21.2094 5.7896 1.0 0.0 1.0
2020-02-11 30.71 32.9515 32.9762 -0.0247 0.0 -1.0 0.0
2020-02-12 29.56 32.7030 33.1278 -0.4248 0.0 0.0 -1.0
2020-03-17 66.60 35.9460 35.0848 0.8612 1.0 1.0 0.0
2020-03-18 92.00 38.9335 36.0332 2.9003 1.0 0.0 1.0
2020-05-05 50.00 45.3605 45.8842 -0.5237 0.0 -1.0 0.0
2020-05-06 47.78 45.4695 46.1710 -0.7015 0.0 0.0 -1.0
2020-05-15 49.49 48.1010 47.9788 0.1222 1.0 1.0 0.0
2020-05-18 60.17 48.9410 48.4204 0.5206 1.0 0.0 1.0
2020-05-21 51.90 49.4295 49.5388 -0.1093 0.0 -1.0 0.0
2020-05-22 51.03 49.5935 49.9884 -0.3949 0.0 0.0 -1.0
2020-05-29 49.53 49.7390 49.2952 0.4438 1.0 1.0 0.0
List the signal change and entry/exit points for BSX
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-25 37.45 35.7770 35.6620 0.1150 1.0 1.0 0.0
2019-01-28 36.85 35.8955 35.6604 0.2351 1.0 0.0 1.0
2019-04-01 38.66 38.8550 38.8842 -0.0292 0.0 -1.0 0.0
2019-04-02 38.52 38.7715 38.9008 -0.1293 0.0 0.0 -1.0
2019-05-30 38.44 37.3630 37.3368 0.0262 1.0 1.0 0.0
2019-05-31 38.41 37.4390 37.3478 0.0912 1.0 0.0 1.0
2019-08-27 42.22 42.3005 42.3194 -0.0189 0.0 -1.0 0.0
2019-08-28 42.49 42.3020 42.3504 -0.0484 0.0 0.0 -1.0
2019-09-23 43.15 42.3980 42.3766 0.0214 1.0 1.0 0.0
2019-09-24 42.33 42.4220 42.3742 0.0478 1.0 0.0 1.0
2019-09-27 40.31 42.2875 42.3366 -0.0491 0.0 -1.0 0.0
2019-09-30 40.69 42.1855 42.3054 -0.1199 0.0 0.0 -1.0
2019-11-15 42.31 40.8530 40.6990 0.1540 1.0 1.0 0.0
2019-11-18 42.29 41.0350 40.7100 0.3250 1.0 0.0 1.0
2020-02-03 42.23 43.9205 44.0154 -0.0949 0.0 -1.0 0.0
2020-02-04 42.88 43.7970 44.0208 -0.2238 0.0 0.0 -1.0
2020-04-28 35.93 34.8625 34.7148 0.1477 1.0 1.0 0.0
2020-04-29 37.43 35.1025 34.6202 0.4823 1.0 0.0 1.0
List the signal change and entry/exit points for BYND
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-07-12 166.81 159.0500 119.9926 39.0574 1.0 1.0 0.0
2019-07-15 166.53 159.8025 122.0082 37.7943 1.0 0.0 1.0
2019-08-23 146.85 166.7170 168.4318 -1.7148 0.0 -1.0 0.0
2019-08-26 155.13 163.3670 168.5048 -5.1378 0.0 0.0 -1.0
2020-01-13 114.34 80.2690 79.1913 1.0777 1.0 1.0 0.0
2020-01-14 117.05 82.3705 79.8433 2.5272 1.0 0.0 1.0
2020-03-12 74.00 103.3765 105.2430 -1.8665 0.0 -1.0 0.0
2020-03-13 73.06 101.4290 105.1922 -3.7632 0.0 0.0 -1.0
2020-05-01 91.53 83.3525 81.8386 1.5139 1.0 1.0 0.0
2020-05-04 95.16 85.1150 81.3928 3.7222 1.0 0.0 1.0
List the signal change and entry/exit points for CAG
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-02-27 23.09 22.9065 22.6786 0.2279 1.0 1.0 0.0
2019-02-28 23.37 23.0030 22.5482 0.4548 1.0 0.0 1.0
2019-05-31 26.77 28.6495 28.8540 -0.2045 0.0 -1.0 0.0
2019-06-03 27.52 28.5250 28.8880 -0.3630 0.0 0.0 -1.0
2019-07-31 28.87 28.4810 28.4732 0.0078 1.0 1.0 0.0
2019-08-01 29.14 28.5250 28.4848 0.0402 1.0 0.0 1.0
2019-10-16 26.92 28.8780 28.8857 -0.0077 0.0 -1.0 0.0
2019-10-17 27.39 28.7645 28.8741 -0.1096 0.0 0.0 -1.0
2019-11-29 28.87 28.3690 28.3180 0.0510 1.0 1.0 0.0
2019-12-02 28.76 28.4335 28.2970 0.1365 1.0 0.0 1.0
2020-02-24 29.23 31.9455 32.0924 -0.1469 0.0 -1.0 0.0
2020-02-25 28.38 31.7380 32.0874 -0.3494 0.0 0.0 -1.0
2020-04-15 32.87 29.2960 29.2920 0.0040 1.0 1.0 0.0
2020-04-16 33.47 29.6065 29.3230 0.2835 1.0 0.0 1.0
List the signal change and entry/exit points for CCI
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-07 108.60 110.3150 110.4212 -0.1062 0.0 -1.0 0.0
2019-02-05 119.22 111.2345 111.0696 0.1649 1.0 1.0 0.0
2019-02-06 117.36 111.7255 111.2274 0.4981 1.0 0.0 1.0
2019-05-09 124.03 124.5295 124.8024 -0.2729 0.0 -1.0 0.0
2019-05-10 125.68 124.3770 124.9410 -0.5640 0.0 0.0 -1.0
2019-06-03 131.83 126.4240 126.2116 0.2124 1.0 1.0 0.0
2019-06-04 131.86 126.7785 126.3388 0.4397 1.0 0.0 1.0
2019-07-26 130.58 131.4475 131.4904 -0.0429 0.0 -1.0 0.0
2019-07-29 130.16 131.4380 131.5430 -0.1050 0.0 0.0 -1.0
2019-08-15 142.41 134.4345 134.0258 0.4087 1.0 1.0 0.0
2019-08-16 142.92 135.3065 134.1832 1.1233 1.0 0.0 1.0
2019-10-03 137.34 139.9675 140.4818 -0.5143 0.0 -1.0 0.0
2019-10-04 137.92 139.5415 140.6508 -1.1093 0.0 0.0 -1.0
2019-12-30 141.40 136.4865 136.1674 0.3191 1.0 1.0 0.0
2019-12-31 142.15 137.0465 136.1292 0.9173 1.0 0.0 1.0
2020-03-20 128.06 151.2820 152.0238 -0.7418 0.0 -1.0 0.0
2020-03-23 116.98 148.8130 151.5584 -2.7454 0.0 0.0 -1.0
2020-04-23 160.55 153.9070 152.6478 1.2592 1.0 1.0 0.0
2020-04-24 161.61 154.8640 152.6158 2.2482 1.0 0.0 1.0
List the signal change and entry/exit points for CHGG
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-04-12 37.32 38.2160 38.2556 -0.0396 0.0 -1.0 0.0
2019-06-12 38.85 37.4770 37.4302 0.0468 1.0 1.0 0.0
2019-06-13 38.84 37.5965 37.4414 0.1551 1.0 0.0 1.0
2019-08-28 40.17 41.7555 41.8050 -0.0495 0.0 -1.0 0.0
2019-08-29 40.45 41.5265 41.8160 -0.2895 0.0 0.0 -1.0
2019-11-12 35.34 32.5825 32.5522 0.0303 1.0 1.0 0.0
2019-11-13 36.05 32.7700 32.5208 0.2492 1.0 0.0 1.0
2020-03-03 39.26 40.5035 40.5140 -0.0105 0.0 -1.0 0.0
2020-03-04 39.79 40.3615 40.5362 -0.1747 0.0 0.0 -1.0
2020-04-27 41.85 36.8660 36.8334 0.0326 1.0 1.0 0.0
2020-04-28 41.15 37.0985 36.8548 0.2437 1.0 0.0 1.0
List the signal change and entry/exit points for CHWY
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-12-18 27.91 25.1395 25.1288 0.0107 1.0 1.0 0.0
2019-12-19 28.56 25.4075 25.1922 0.2153 1.0 0.0 1.0
2020-02-18 28.92 28.2840 28.3654 -0.0814 0.0 -1.0 0.0
2020-02-19 29.30 28.2420 28.4648 -0.2228 0.0 0.0 -1.0
2020-03-05 28.52 28.9385 28.9376 0.0009 1.0 1.0 0.0
2020-03-06 28.02 28.9540 28.9292 0.0248 1.0 0.0 1.0
2020-03-11 25.46 28.7640 28.7892 -0.0252 0.0 -1.0 0.0
2020-03-12 22.77 28.4975 28.6748 -0.1773 0.0 0.0 -1.0
2020-03-26 33.81 28.8735 28.8474 0.0261 1.0 1.0 0.0
2020-03-27 36.16 29.2015 28.9606 0.2409 1.0 0.0 1.0
List the signal change and entry/exit points for CL
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-03 58.97 61.78350 61.8948 -0.11130 0.0 -1.0 0.0
2019-02-01 65.05 62.20000 62.1516 0.04840 1.0 1.0 0.0
2019-02-04 65.19 62.48350 62.2000 0.28350 1.0 0.0 1.0
2019-08-07 70.44 72.61150 72.6214 -0.00990 0.0 -1.0 0.0
2019-08-08 71.71 72.50250 72.6562 -0.15370 0.0 0.0 -1.0
2019-09-05 74.29 72.76925 72.7143 0.05495 1.0 1.0 0.0
2019-09-06 74.70 72.91875 72.7613 0.15745 1.0 0.0 1.0
2019-10-01 71.73 72.22050 72.2683 -0.04780 0.0 -1.0 0.0
2019-10-02 70.52 72.00300 72.2331 -0.23010 0.0 0.0 -1.0
2019-12-18 68.27 67.74200 67.7236 0.01840 1.0 1.0 0.0
2019-12-19 68.34 67.79850 67.6778 0.12070 1.0 0.0 1.0
2020-03-16 62.34 71.61850 71.8872 -0.26870 0.0 -1.0 0.0
2020-03-17 70.20 71.32500 71.9308 -0.60580 0.0 0.0 -1.0
2020-04-27 71.03 70.15500 69.7880 0.36700 1.0 1.0 0.0
2020-04-28 71.11 70.38150 69.6764 0.70510 1.0 0.0 1.0
List the signal change and entry/exit points for CLX
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-03 152.03 157.3295 157.8078 -0.4783 0.0 -1.0 0.0
2019-02-25 157.60 153.8580 153.6766 0.1814 1.0 1.0 0.0
2019-02-26 158.03 154.4225 153.5604 0.8621 1.0 0.0 1.0
2019-04-15 154.45 157.0145 157.1276 -0.1131 0.0 -1.0 0.0
2019-04-16 152.34 156.7880 157.0068 -0.2188 0.0 0.0 -1.0
2019-06-14 156.88 152.2405 152.2358 0.0047 1.0 1.0 0.0
2019-06-17 154.82 152.6290 152.1928 0.4362 1.0 0.0 1.0
2019-08-28 159.98 158.0775 158.1304 -0.0529 0.0 -1.0 0.0
2019-08-29 159.25 158.2330 158.2538 -0.0208 0.0 0.0 -1.0
2019-09-03 162.35 158.6620 158.4740 0.1880 1.0 1.0 0.0
2019-09-04 164.36 159.1640 158.6570 0.5070 1.0 0.0 1.0
2019-09-16 153.77 159.3330 159.4612 -0.1282 0.0 -1.0 0.0
2019-09-17 155.54 159.0035 159.4344 -0.4309 0.0 0.0 -1.0
2019-12-16 151.59 149.1610 148.8836 0.2774 1.0 1.0 0.0
2019-12-17 150.08 149.3780 148.8620 0.5160 1.0 0.0 1.0
List the signal change and entry/exit points for CMG
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-22 520.08 468.7085 468.4224 0.2861 1.0 1.0 0.0
2019-01-23 521.37 475.0560 469.3000 5.7560 1.0 0.0 1.0
2019-05-31 659.97 696.4380 697.5424 -1.1044 0.0 -1.0 0.0
2019-06-03 641.66 693.0450 696.9666 -3.9216 0.0 0.0 -1.0
2019-06-21 726.85 703.0255 701.9748 1.0507 1.0 1.0 0.0
2019-06-24 724.13 706.1040 702.3068 3.7972 1.0 0.0 1.0
2019-10-24 798.34 823.0290 823.2634 -0.2344 0.0 -1.0 0.0
2019-10-25 787.87 821.4810 822.8230 -1.3420 0.0 0.0 -1.0
2019-12-11 822.74 794.9040 794.6714 0.2326 1.0 1.0 0.0
2019-12-12 811.20 797.7990 794.6958 3.1032 1.0 0.0 1.0
2020-03-04 769.76 859.6475 860.1598 -0.5123 0.0 -1.0 0.0
2020-03-05 727.55 853.3245 858.0202 -4.6957 0.0 0.0 -1.0
2020-04-24 882.47 740.7020 733.3240 7.3780 1.0 1.0 0.0
2020-04-27 883.07 753.1040 732.7264 20.3776 1.0 0.0 1.0
List the signal change and entry/exit points for CNC
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-02-06 126.16 126.0840 125.9412 0.1428 1.0 1.0 0.0
2019-02-07 63.91 123.3680 124.4956 -1.1276 0.0 -1.0 1.0
2019-02-08 62.90 120.5920 122.9846 -2.3926 0.0 0.0 -1.0
2019-05-23 55.42 54.4610 54.3910 0.0700 1.0 1.0 0.0
2019-05-24 56.87 54.6730 54.3408 0.3322 1.0 0.0 1.0
2019-07-01 51.35 54.0495 54.0958 -0.0463 0.0 -1.0 0.0
2019-07-02 51.54 53.9295 54.1650 -0.2355 0.0 0.0 -1.0
2019-10-29 49.91 45.7145 45.6260 0.0885 1.0 1.0 0.0
2019-10-30 54.04 46.2800 45.7760 0.5040 1.0 0.0 1.0
2020-02-27 52.62 62.8200 63.2444 -0.4244 0.0 -1.0 0.0
2020-02-28 53.02 62.2950 63.1044 -0.8094 0.0 0.0 -1.0
2020-04-20 68.42 60.4570 59.7740 0.6830 1.0 1.0 0.0
2020-04-21 66.24 61.4915 59.8356 1.6559 1.0 0.0 1.0
List the signal change and entry/exit points for COR
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-02-01 98.61 93.3250 92.8680 0.4570 1.0 1.0 0.0
2019-02-04 99.22 93.9050 92.9704 0.9346 1.0 0.0 1.0
2019-07-26 105.18 116.2450 116.2564 -0.0114 0.0 -1.0 0.0
2019-07-29 104.34 115.7035 116.0128 -0.3093 0.0 0.0 -1.0
2019-09-06 119.12 113.8440 113.6988 0.1452 1.0 1.0 0.0
2019-09-09 114.79 114.0235 113.7128 0.3107 1.0 0.0 1.0
2019-11-14 113.66 117.8780 117.9236 -0.0456 0.0 -1.0 0.0
2019-11-15 115.43 117.5880 117.8498 -0.2618 0.0 0.0 -1.0
2020-01-22 117.81 113.2110 113.0742 0.1368 1.0 1.0 0.0
2020-01-23 117.09 113.4905 113.1434 0.3471 1.0 0.0 1.0
2020-02-28 103.73 113.3585 113.8056 -0.4471 0.0 -1.0 0.0
2020-03-02 109.52 112.9620 113.7614 -0.7994 0.0 0.0 -1.0
2020-04-16 118.50 111.0965 110.4892 0.6073 1.0 1.0 0.0
2020-04-17 119.25 111.7555 110.5114 1.2441 1.0 0.0 1.0
List the signal change and entry/exit points for COST
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-02-13 212.80 211.05200 211.0224 0.02960 1.0 1.0 0.0
2019-02-14 213.84 211.23500 210.6736 0.56140 1.0 0.0 1.0
2019-12-13 291.87 298.22625 298.5415 -0.31525 0.0 -1.0 0.0
2019-12-16 293.50 297.71825 298.5781 -0.85985 0.0 0.0 -1.0
2020-01-23 312.88 298.85200 298.2633 0.58870 1.0 1.0 0.0
2020-01-24 310.51 299.66600 298.4567 1.20930 1.0 0.0 1.0
2020-03-17 306.99 305.41550 306.4524 -1.03690 0.0 -1.0 0.0
2020-03-18 307.50 304.63950 306.7662 -2.12670 0.0 0.0 -1.0
2020-04-27 308.78 303.44800 302.9746 0.47340 1.0 1.0 0.0
2020-04-28 304.95 304.13950 302.7074 1.43210 1.0 0.0 1.0
List the signal change and entry/exit points for COUP
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-03 58.760 61.85875 61.9579 -0.09915 0.0 -1.0 0.0
2019-01-04 62.510 61.93450 61.9091 0.02540 1.0 1.0 0.0
2019-01-07 65.150 61.88550 61.9271 -0.04160 0.0 -1.0 1.0
2019-01-08 65.910 62.17550 62.0533 0.12220 1.0 1.0 -1.0
2019-01-09 65.640 62.22900 62.1297 0.09930 1.0 0.0 1.0
2019-01-10 64.690 62.23550 62.2419 -0.00640 0.0 -1.0 0.0
2019-01-11 64.990 62.22650 62.3793 -0.15280 0.0 0.0 -1.0
2019-01-16 68.830 62.76100 62.5607 0.20030 1.0 1.0 0.0
2019-01-17 73.620 63.30900 62.7115 0.59750 1.0 0.0 1.0
2019-04-08 90.820 91.96150 92.0395 -0.07800 0.0 -1.0 0.0
2019-04-09 92.570 92.06350 92.2927 -0.22920 0.0 0.0 -1.0
2019-04-26 102.040 93.55500 93.4032 0.15180 1.0 1.0 0.0
2019-04-29 102.600 94.13600 93.5508 0.58520 1.0 0.0 1.0
2019-09-27 127.890 138.62650 138.8054 -0.17890 0.0 -1.0 0.0
2019-09-30 129.570 138.15850 138.5186 -0.36010 0.0 0.0 -1.0
2019-10-09 150.135 138.74975 138.6829 0.06685 1.0 1.0 0.0
2019-10-10 153.640 139.62275 139.0415 0.58125 1.0 0.0 1.0
2019-10-24 131.630 139.47625 139.5211 -0.04485 0.0 -1.0 0.0
2019-10-25 133.900 139.77675 139.5239 0.25285 1.0 1.0 -1.0
2019-10-28 134.930 140.04475 139.4575 0.58725 1.0 0.0 1.0
2019-11-04 136.700 139.20125 139.3075 -0.10625 0.0 -1.0 0.0
2019-11-05 130.370 138.58075 139.0311 -0.45035 0.0 0.0 -1.0
2019-11-25 150.600 139.33800 139.1433 0.19470 1.0 1.0 0.0
2019-11-26 153.560 140.25250 139.4547 0.79780 1.0 0.0 1.0
2020-03-04 153.380 160.77250 161.5528 -0.78030 0.0 -1.0 0.0
2020-03-05 151.920 160.43650 161.6056 -1.16910 0.0 0.0 -1.0
2020-04-23 159.870 147.10550 146.7538 0.35170 1.0 1.0 0.0
2020-04-24 163.270 148.13300 146.7120 1.42100 1.0 0.0 1.0
List the signal change and entry/exit points for CPB
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-03-04 36.00 34.6740 34.6634 0.0106 1.0 1.0 0.0
2019-03-05 36.10 34.7285 34.6124 0.1161 1.0 0.0 1.0
2019-05-29 36.22 38.2665 38.3828 -0.1163 0.0 -1.0 0.0
2019-05-30 35.80 38.1405 38.3728 -0.2323 0.0 0.0 -1.0
2019-06-10 42.01 38.7860 38.6998 0.0862 1.0 1.0 0.0
2019-06-11 42.53 38.9765 38.7878 0.1887 1.0 0.0 1.0
2019-11-18 48.04 46.7745 46.8122 -0.0377 0.0 -1.0 0.0
2019-11-19 48.16 46.7990 46.8576 -0.0586 0.0 0.0 -1.0
2019-11-29 46.57 46.9245 46.9130 0.0115 1.0 1.0 0.0
2019-12-02 47.14 46.9545 46.9206 0.0339 1.0 0.0 1.0
2020-02-26 46.64 48.3085 48.3770 -0.0685 0.0 -1.0 0.0
2020-02-27 45.70 48.1765 48.3338 -0.1573 0.0 0.0 -1.0
2020-03-06 51.76 48.4990 48.4962 0.0028 1.0 1.0 0.0
2020-03-09 50.20 48.5650 48.5156 0.0494 1.0 0.0 1.0
2020-03-26 43.59 48.2650 48.2718 -0.0068 0.0 -1.0 0.0
2020-03-27 44.19 48.2185 48.2000 0.0185 1.0 1.0 -1.0
2020-03-30 46.53 48.1460 48.1688 -0.0228 0.0 -1.0 1.0
2020-03-31 46.16 48.0600 48.1316 -0.0716 0.0 0.0 -1.0
2020-04-23 50.54 48.2645 48.2422 0.0223 1.0 1.0 0.0
2020-04-24 50.75 48.6225 48.2936 0.3289 1.0 0.0 1.0
List the signal change and entry/exit points for CRM
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-03 130.40 133.9750 134.1002 -0.1252 0.0 -1.0 0.0
2019-01-08 145.72 134.4075 134.2808 0.1267 1.0 1.0 0.0
2019-01-09 145.99 134.8435 134.3846 0.4589 1.0 0.0 1.0
2019-04-17 155.34 159.5015 159.7472 -0.2457 0.0 -1.0 0.0
2019-04-18 155.99 158.9535 159.7044 -0.7509 0.0 0.0 -1.0
2019-04-29 165.36 160.1290 160.1002 0.0288 1.0 1.0 0.0
2019-04-30 165.35 160.3375 160.2262 0.1113 1.0 0.0 1.0
2019-05-21 155.78 159.5120 159.7182 -0.2062 0.0 -1.0 0.0
2019-05-22 157.64 159.4160 159.7054 -0.2894 0.0 0.0 -1.0
2019-07-17 158.24 154.7460 154.5682 0.1778 1.0 1.0 0.0
2019-07-18 157.98 154.9380 154.5898 0.3482 1.0 0.0 1.0
2019-08-09 143.37 153.0700 153.2818 -0.2118 0.0 -1.0 0.0
2019-08-12 140.72 152.1235 153.0680 -0.9445 0.0 0.0 -1.0
2019-09-17 152.82 152.1070 151.6950 0.4120 1.0 1.0 0.0
2019-09-18 152.77 152.4685 151.6714 0.7971 1.0 0.0 1.0
2019-10-17 146.17 149.1830 149.4674 -0.2844 0.0 -1.0 0.0
2019-10-18 144.09 148.6275 149.4728 -0.8453 0.0 0.0 -1.0
2019-11-07 159.50 151.8950 151.4436 0.4514 1.0 1.0 0.0
2019-11-08 161.11 152.4820 151.5472 0.9348 1.0 0.0 1.0
2020-03-10 161.34 179.0330 179.4130 -0.3800 0.0 -1.0 0.0
2020-03-11 154.57 177.3060 179.2048 -1.8988 0.0 0.0 -1.0
2020-05-04 161.47 155.4640 154.3628 1.1012 1.0 1.0 0.0
2020-05-05 163.25 156.2490 153.9090 2.3400 1.0 0.0 1.0
List the signal change and entry/exit points for CRWD
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-08-22 92.97 92.4350 80.2752 12.1598 1.0 1.0 0.0
2019-08-23 88.43 92.2125 80.6926 11.5199 1.0 0.0 1.0
2019-09-13 64.86 83.5955 83.6064 -0.0109 0.0 -1.0 0.0
2019-09-16 67.86 82.1860 83.6194 -1.4334 0.0 0.0 -1.0
2019-12-06 50.89 53.8885 53.7765 0.1120 1.0 1.0 0.0
2019-12-09 49.00 53.9780 53.6873 0.2907 1.0 0.0 1.0
2019-12-27 48.92 50.5840 50.7687 -0.1847 0.0 -1.0 0.0
2019-12-30 50.03 50.1855 50.7605 -0.5750 0.0 0.0 -1.0
2020-01-15 60.25 52.4625 52.1828 0.2797 1.0 1.0 0.0
2020-01-16 62.24 53.1550 52.4346 0.7204 1.0 0.0 1.0
2020-03-11 42.85 57.9615 58.5578 -0.5963 0.0 -1.0 0.0
2020-03-12 37.82 56.5985 58.3136 -1.7151 0.0 0.0 -1.0
2020-04-16 63.45 56.8650 55.9627 0.9023 1.0 1.0 0.0
2020-04-17 64.74 58.0150 56.0212 1.9938 1.0 0.0 1.0
List the signal change and entry/exit points for CTXS
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-03 100.74 105.3200 105.4146 -0.0946 0.0 -1.0 0.0
2019-02-26 105.43 104.8560 104.7172 0.1388 1.0 1.0 0.0
2019-02-27 105.36 105.0645 104.6192 0.4453 1.0 0.0 1.0
2019-03-12 100.20 104.4445 104.4676 -0.0231 0.0 -1.0 0.0
2019-03-13 100.56 104.2005 104.4428 -0.2423 0.0 0.0 -1.0
2019-07-02 99.29 97.4820 97.2466 0.2354 1.0 1.0 0.0
2019-07-03 99.69 97.7200 97.2228 0.4972 1.0 0.0 1.0
2019-08-08 92.42 97.0230 97.2718 -0.2488 0.0 -1.0 0.0
2019-08-09 91.98 96.5800 97.2166 -0.6366 0.0 0.0 -1.0
2019-09-24 95.16 94.9360 94.8260 0.1100 1.0 1.0 0.0
2019-09-25 95.97 95.1140 94.7284 0.3856 1.0 0.0 1.0
2020-03-04 110.13 115.8520 116.4282 -0.5762 0.0 -1.0 0.0
2020-03-05 116.46 115.5375 116.5362 -0.9987 0.0 0.0 -1.0
2020-03-30 145.91 121.1260 119.9890 1.1370 1.0 1.0 0.0
2020-03-31 141.55 122.8835 120.4756 2.4079 1.0 0.0 1.0
List the signal change and entry/exit points for D
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-10 71.90 73.1615 73.2436 -0.0821 0.0 -1.0 0.0
2019-02-25 75.12 72.2805 71.9706 0.3099 1.0 1.0 0.0
2019-02-26 73.89 72.5565 71.9432 0.6133 1.0 0.0 1.0
2019-05-08 73.81 75.9810 76.0254 -0.0444 0.0 -1.0 0.0
2019-05-09 73.31 75.8550 76.0050 -0.1500 0.0 0.0 -1.0
2019-06-13 76.07 75.9960 75.9256 0.0704 1.0 1.0 0.0
2019-06-14 76.66 76.0630 75.9196 0.1434 1.0 0.0 1.0
2019-08-01 75.91 76.6095 76.6362 -0.0267 0.0 -1.0 0.0
2019-08-02 76.02 76.5155 76.6100 -0.0945 0.0 0.0 -1.0
2019-09-05 77.43 76.7455 76.6096 0.1359 1.0 1.0 0.0
2019-09-06 76.37 76.7975 76.6078 0.1897 1.0 0.0 1.0
2019-12-20 82.32 81.7875 81.8116 -0.0241 0.0 -1.0 0.0
2019-12-23 81.43 81.6970 81.8022 -0.1052 0.0 0.0 -1.0
2020-01-13 82.05 81.8425 81.7894 0.0531 1.0 1.0 0.0
2020-01-14 81.95 81.8960 81.7774 0.1186 1.0 0.0 1.0
2020-03-16 68.65 83.5740 83.8802 -0.3062 0.0 -1.0 0.0
2020-03-17 80.48 83.1490 83.8546 -0.7056 0.0 0.0 -1.0
2020-05-01 75.61 77.8160 77.7888 0.0272 1.0 1.0 0.0
2020-05-04 75.80 78.1285 77.5172 0.6113 1.0 0.0 1.0
List the signal change and entry/exit points for DDOG
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-11-27 41.86 37.42100 35.1790 2.24200 1.0 1.0 0.0
2019-11-29 40.77 37.78000 35.2434 2.53660 1.0 0.0 1.0
2020-03-16 28.96 42.18025 42.9096 -0.72935 0.0 -1.0 0.0
2020-03-17 34.12 41.53225 42.8436 -1.31135 0.0 0.0 -1.0
2020-04-29 44.65 39.03650 39.0119 0.02460 1.0 1.0 0.0
2020-04-30 45.12 39.54850 38.9683 0.58020 1.0 0.0 1.0
List the signal change and entry/exit points for DG
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-18 113.53 109.4295 109.2092 0.2203 1.0 1.0 0.0
2019-01-22 112.90 110.0575 109.1794 0.8781 1.0 0.0 1.0
2019-05-29 118.51 121.2410 121.3776 -0.1366 0.0 -1.0 0.0
2019-05-30 127.00 121.4000 121.5728 -0.1728 0.0 0.0 -1.0
2019-06-06 131.46 122.8960 122.7368 0.1592 1.0 1.0 0.0
2019-06-07 133.15 123.4055 123.0256 0.3799 1.0 0.0 1.0
2019-08-13 135.38 136.7025 136.9318 -0.2293 0.0 -1.0 0.0
2019-08-14 133.85 136.1465 137.0088 -0.8623 0.0 0.0 -1.0
2019-08-30 156.09 138.5300 138.3812 0.1488 1.0 1.0 0.0
2019-09-03 155.63 139.6790 138.7182 0.9608 1.0 0.0 1.0
2019-11-20 160.95 159.7890 159.7992 -0.0102 0.0 -1.0 0.0
2019-11-21 160.78 159.6825 159.8728 -0.1903 0.0 0.0 -1.0
2020-02-06 155.47 155.7215 155.5490 0.1725 1.0 1.0 0.0
2020-02-07 154.97 155.8410 155.4500 0.3910 1.0 0.0 1.0
2020-03-19 143.00 155.4610 156.1896 -0.7286 0.0 -1.0 0.0
2020-03-20 140.13 154.1235 155.9612 -1.8377 0.0 0.0 -1.0
2020-04-16 180.13 157.2350 157.1586 0.0764 1.0 1.0 0.0
2020-04-17 182.11 159.1905 157.6556 1.5349 1.0 0.0 1.0
List the signal change and entry/exit points for DHR
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-23 106.13 102.9140 102.8724 0.0416 1.0 1.0 0.0
2019-01-24 106.05 103.4740 102.8984 0.5756 1.0 0.0 1.0
2019-08-13 140.54 140.7085 140.7498 -0.0413 0.0 -1.0 0.0
2019-08-14 136.36 140.5440 140.8280 -0.2840 0.0 0.0 -1.0
2019-09-19 145.75 140.5585 140.5004 0.0581 1.0 1.0 0.0
2019-09-20 146.47 140.9040 140.5756 0.3284 1.0 0.0 1.0
2019-10-18 138.01 140.0440 140.2762 -0.2322 0.0 -1.0 0.0
2019-10-21 138.23 139.7255 140.2346 -0.5091 0.0 0.0 -1.0
2019-11-29 145.98 139.6440 139.5170 0.1270 1.0 1.0 0.0
2019-12-02 145.69 140.1000 139.5014 0.5986 1.0 0.0 1.0
2020-03-04 155.98 158.2640 158.6242 -0.3602 0.0 -1.0 0.0
2020-03-05 149.47 157.5930 158.5566 -0.9636 0.0 0.0 -1.0
2020-04-23 160.65 146.0380 145.5876 0.4504 1.0 1.0 0.0
2020-04-24 165.07 147.3585 145.6124 1.7461 1.0 0.0 1.0
List the signal change and entry/exit points for DOCU
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-18 47.00 41.7135 41.5694 0.1441 1.0 1.0 0.0
2019-01-22 45.85 42.0105 41.6354 0.3751 1.0 0.0 1.0
2019-04-12 55.25 54.1560 54.2730 -0.1170 0.0 -1.0 0.0
2019-04-15 55.42 54.0395 54.3822 -0.3427 0.0 0.0 -1.0
2019-05-01 55.82 55.0725 55.0684 0.0041 1.0 1.0 0.0
2019-05-02 54.89 55.1100 55.0840 0.0260 1.0 0.0 1.0
2019-05-13 50.42 54.8630 54.9158 -0.0528 0.0 -1.0 0.0
2019-05-14 52.54 54.7190 54.8554 -0.1364 0.0 0.0 -1.0
2019-05-20 53.17 54.7120 54.7098 0.0022 1.0 1.0 0.0
2019-05-21 54.76 54.6880 54.6620 0.0260 1.0 0.0 1.0
2019-05-23 53.21 54.4450 54.5232 -0.0782 0.0 -1.0 0.0
2019-05-24 54.10 54.2870 54.4282 -0.1412 0.0 0.0 -1.0
2019-07-26 54.68 52.5115 52.4016 0.1099 1.0 1.0 0.0
2019-07-29 53.90 52.7210 52.3848 0.3362 1.0 0.0 1.0
2019-08-08 46.36 51.2555 51.4414 -0.1859 0.0 -1.0 0.0
2019-08-09 45.33 50.8620 51.2384 -0.3764 0.0 0.0 -1.0
2019-09-16 61.88 50.8260 50.3688 0.4572 1.0 1.0 0.0
2019-09-17 61.90 51.6940 50.5738 1.1202 1.0 0.0 1.0
2020-03-24 85.00 80.5715 80.5748 -0.0033 0.0 -1.0 0.0
2020-03-25 81.37 80.4610 80.7192 -0.2582 0.0 0.0 -1.0
2020-04-14 98.43 85.2210 84.3528 0.8682 1.0 1.0 0.0
2020-04-15 100.53 86.7005 84.7508 1.9497 1.0 0.0 1.0
List the signal change and entry/exit points for DPZ
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-30 277.06 257.5820 256.5086 1.0734 1.0 1.0 0.0
2019-01-31 283.73 259.6035 256.9908 2.6127 1.0 0.0 1.0
2019-03-12 240.00 260.5580 263.1004 -2.5424 0.0 -1.0 0.0
2019-03-13 245.37 258.4660 263.0088 -4.5428 0.0 0.0 -1.0
2019-04-24 283.42 256.7515 255.8290 0.9225 1.0 1.0 0.0
2019-04-25 276.45 258.1950 255.6138 2.5812 1.0 0.0 1.0
2019-07-08 277.21 278.9415 279.2016 -0.2601 0.0 -1.0 0.0
2019-07-09 280.00 278.8095 279.3330 -0.5235 0.0 0.0 -1.0
2019-09-27 240.46 241.8605 241.7574 0.1031 1.0 1.0 0.0
2019-09-30 244.59 242.7480 241.4906 1.2574 1.0 0.0 1.0
2020-01-28 284.18 288.6090 288.8298 -0.2208 0.0 -1.0 0.0
2020-01-29 285.47 288.2200 288.9660 -0.7460 0.0 0.0 -1.0
2020-02-21 371.96 291.3065 290.6252 0.6813 1.0 1.0 0.0
2020-02-24 363.01 295.2020 292.1806 3.0214 1.0 0.0 1.0
List the signal change and entry/exit points for DXCM
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-22 150.82 130.11800 128.9064 1.21160 1.0 1.0 0.0
2019-01-23 146.54 132.02900 128.9442 3.08480 1.0 0.0 1.0
2019-03-19 146.94 143.82600 144.2998 -0.47380 0.0 -1.0 0.0
2019-03-20 146.16 143.85700 144.6240 -0.76700 0.0 0.0 -1.0
2019-06-03 120.96 119.11000 118.9004 0.20960 1.0 1.0 0.0
2019-06-04 124.75 119.23700 118.8148 0.42220 1.0 0.0 1.0
2019-09-26 149.89 156.27950 157.3140 -1.03450 0.0 -1.0 0.0
2019-09-27 148.51 155.10200 157.2164 -2.11440 0.0 0.0 -1.0
2019-11-07 194.70 155.89800 155.5008 0.39720 1.0 1.0 0.0
2019-11-08 198.08 158.03450 156.0212 2.01330 1.0 0.0 1.0
2020-03-24 236.21 249.79850 250.5336 -0.73510 0.0 -1.0 0.0
2020-03-25 239.33 247.85250 250.6034 -2.75090 0.0 0.0 -1.0
2020-04-17 323.40 263.31575 262.4381 0.87765 1.0 1.0 0.0
2020-04-20 323.27 269.00425 264.1235 4.88075 1.0 0.0 1.0
List the signal change and entry/exit points for EA
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-22 91.31 84.9340 84.5428 0.3912 1.0 1.0 0.0
2019-01-23 89.13 85.5620 84.4494 1.1126 1.0 0.0 1.0
2019-04-22 92.52 98.8555 99.0174 -0.1619 0.0 -1.0 0.0
2019-04-23 94.63 98.5005 98.9580 -0.4575 0.0 0.0 -1.0
2019-06-25 96.90 94.1180 94.0942 0.0238 1.0 1.0 0.0
2019-06-26 97.32 94.3565 94.0836 0.2729 1.0 0.0 1.0
2019-07-23 88.22 94.0110 94.0760 -0.0650 0.0 -1.0 0.0
2019-07-24 89.78 93.6550 94.0632 -0.4082 0.0 0.0 -1.0
2019-09-05 97.45 92.9905 92.7994 0.1911 1.0 1.0 0.0
2019-09-06 98.53 93.1555 92.8236 0.3319 1.0 0.0 1.0
2019-10-21 95.81 95.2355 95.2470 -0.0115 0.0 -1.0 0.0
2019-10-22 94.30 95.0825 95.2976 -0.2151 0.0 0.0 -1.0
2019-11-15 97.54 96.6020 96.5488 0.0532 1.0 1.0 0.0
2019-11-18 97.39 96.6810 96.5230 0.1580 1.0 0.0 1.0
2020-02-26 106.54 108.6090 108.8882 -0.2792 0.0 -1.0 0.0
2020-02-27 102.74 108.1355 108.8520 -0.7165 0.0 0.0 -1.0
2020-04-20 115.41 104.1710 103.7700 0.4010 1.0 1.0 0.0
2020-04-21 113.27 105.0610 103.8536 1.2074 1.0 0.0 1.0
List the signal change and entry/exit points for EBAY
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-18 31.00 29.11650 29.0138 0.10270 1.0 1.0 0.0
2019-01-22 32.90 29.36200 29.0728 0.28920 1.0 0.0 1.0
2019-05-28 36.22 37.10750 37.1218 -0.01430 0.0 -1.0 0.0
2019-05-29 36.10 36.97500 37.1184 -0.14340 0.0 0.0 -1.0
2019-06-19 40.13 37.40750 37.2856 0.12190 1.0 1.0 0.0
2019-06-20 39.92 37.58800 37.3290 0.25900 1.0 0.0 1.0
2019-08-27 39.00 40.01850 40.0520 -0.03350 0.0 -1.0 0.0
2019-08-28 40.09 39.96350 40.0604 -0.09690 0.0 0.0 -1.0
2020-01-02 36.30 35.58650 35.5810 0.00550 1.0 1.0 0.0
2020-01-03 35.96 35.63600 35.5214 0.11460 1.0 0.0 1.0
2020-01-31 33.56 35.38225 35.4395 -0.05725 0.0 -1.0 0.0
2020-02-03 34.39 35.30375 35.4261 -0.12235 0.0 0.0 -1.0
2020-02-06 38.00 35.58075 35.5784 0.00235 1.0 1.0 0.0
2020-02-07 36.20 35.63175 35.5854 0.04635 1.0 0.0 1.0
2020-03-17 33.28 35.86100 35.8967 -0.03570 0.0 -1.0 0.0
2020-03-18 31.30 35.54950 35.8071 -0.25760 0.0 0.0 -1.0
2020-04-27 39.63 34.50125 34.2891 0.21215 1.0 1.0 0.0
2020-04-28 39.08 34.89575 34.3079 0.58785 1.0 0.0 1.0
List the signal change and entry/exit points for EBS
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-02-14 65.01 62.3395 62.2722 0.0673 1.0 1.0 0.0
2019-02-15 66.16 62.5175 62.1306 0.3869 1.0 0.0 1.0
2019-03-11 59.51 61.3000 61.4464 -0.1464 0.0 -1.0 0.0
2019-03-12 56.98 60.9275 61.4144 -0.4869 0.0 0.0 -1.0
2019-07-10 44.29 45.8400 45.6644 0.1756 1.0 1.0 0.0
2019-07-11 43.67 45.8075 45.5042 0.3033 1.0 0.0 1.0
2019-07-26 44.41 44.3615 44.5176 -0.1561 0.0 -1.0 0.0
2019-07-29 43.57 44.1245 44.4842 -0.3597 0.0 0.0 -1.0
2019-09-06 56.08 44.9315 44.6388 0.2927 1.0 1.0 0.0
2019-09-09 56.63 45.5820 44.8114 0.7706 1.0 0.0 1.0
2019-12-05 52.58 54.1185 54.2222 -0.1037 0.0 -1.0 0.0
2019-12-06 54.98 54.1175 54.3072 -0.1897 0.0 0.0 -1.0
2020-01-15 54.96 54.5070 54.3822 0.1248 1.0 1.0 0.0
2020-01-16 56.04 54.6750 54.3718 0.3032 1.0 0.0 1.0
2020-03-19 53.10 58.3725 58.5034 -0.1309 0.0 -1.0 0.0
2020-03-20 49.34 57.5425 58.3890 -0.8465 0.0 0.0 -1.0
2020-04-21 66.96 60.0820 59.5012 0.5808 1.0 1.0 0.0
2020-04-22 66.60 60.6160 59.5964 1.0196 1.0 0.0 1.0
List the signal change and entry/exit points for EQIX
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-02-01 396.38 373.6765 373.2630 0.4135 1.0 1.0 0.0
2019-02-04 395.29 375.7515 373.4994 2.2521 1.0 0.0 1.0
2019-11-07 522.50 561.2240 561.9804 -0.7564 0.0 -1.0 0.0
2019-11-08 530.31 559.4090 561.4322 -2.0232 0.0 0.0 -1.0
2019-12-16 562.80 558.7400 558.5138 0.2262 1.0 1.0 0.0
2019-12-17 557.52 558.7055 558.1180 0.5875 1.0 0.0 1.0
2020-03-19 550.00 602.2160 604.2955 -2.0795 0.0 -1.0 0.0
2020-03-20 506.52 594.7425 602.7499 -8.0074 0.0 0.0 -1.0
2020-04-16 682.74 613.7225 612.9719 0.7506 1.0 1.0 0.0
2020-04-17 694.95 620.9700 614.8457 6.1243 1.0 0.0 1.0
List the signal change and entry/exit points for ETSY
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-14 52.040 49.40050 49.4848 -0.08430 0.0 -1.0 0.0
2019-01-24 54.340 51.32500 50.7948 0.53020 1.0 1.0 0.0
2019-01-25 55.000 51.73000 50.8546 0.87540 1.0 0.0 1.0
2019-05-01 66.790 66.79000 67.1058 -0.31580 0.0 -1.0 0.0
2019-05-02 68.070 66.72050 67.3836 -0.66310 0.0 0.0 -1.0
2019-06-21 65.780 65.22300 65.1224 0.10060 1.0 1.0 0.0
2019-06-24 63.930 65.18400 65.0480 0.13600 1.0 0.0 1.0
2019-07-19 65.850 63.95450 64.0072 -0.05270 0.0 -1.0 0.0
2019-07-22 68.530 64.09200 64.1626 -0.07060 0.0 0.0 -1.0
2019-07-23 67.820 64.28650 64.2830 0.00350 1.0 1.0 0.0
2019-07-24 68.050 64.59950 64.4994 0.10010 1.0 0.0 1.0
2019-08-08 58.040 64.41200 64.5062 -0.09420 0.0 -1.0 0.0
2019-08-09 56.430 64.00350 64.3758 -0.37230 0.0 0.0 -1.0
2019-10-07 55.920 56.35700 55.8686 0.48840 1.0 1.0 0.0
2019-10-08 55.210 56.59100 55.5904 1.00060 1.0 0.0 1.0
2019-11-06 42.620 54.29675 54.7210 -0.42425 0.0 -1.0 0.0
2019-11-07 41.860 53.50125 54.4714 -0.97015 0.0 0.0 -1.0
2020-01-08 45.005 43.83100 43.6802 0.15080 1.0 1.0 0.0
2020-01-09 46.430 44.12700 43.4624 0.66460 1.0 0.0 1.0
2020-03-23 33.030 50.03750 50.3856 -0.34810 0.0 -1.0 0.0
2020-03-24 38.130 49.44950 50.2256 -0.77610 0.0 0.0 -1.0
2020-04-23 62.850 50.37550 50.2396 0.13590 1.0 1.0 0.0
2020-04-24 66.190 51.59100 50.5184 1.07260 1.0 0.0 1.0
List the signal change and entry/exit points for EVBG
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-05-01 72.910 71.84750 72.1258 -0.27830 0.0 -1.0 0.0
2019-05-13 77.460 73.19100 73.1520 0.03900 1.0 1.0 0.0
2019-05-14 79.830 73.57000 73.3734 0.19660 1.0 0.0 1.0
2019-08-19 82.570 91.15800 91.7322 -0.57420 0.0 -1.0 0.0
2019-08-20 83.010 90.45300 91.7054 -1.25240 0.0 0.0 -1.0
2019-11-06 77.480 71.17950 70.9104 0.26910 1.0 1.0 0.0
2019-11-07 77.080 71.66450 70.7776 0.88690 1.0 0.0 1.0
2020-01-07 82.990 80.32500 80.4674 -0.14240 0.0 -1.0 0.0
2020-01-08 82.950 80.25350 80.7090 -0.45550 0.0 0.0 -1.0
2020-01-22 88.710 83.22400 83.2074 0.01660 1.0 1.0 0.0
2020-01-23 87.125 83.58825 83.3889 0.19935 1.0 0.0 1.0
List the signal change and entry/exit points for GILD
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-29 69.59 67.6290 67.2180 0.4110 1.0 1.0 0.0
2019-01-30 69.83 67.9930 67.2036 0.7894 1.0 0.0 1.0
2019-03-04 65.45 66.5930 66.6806 -0.0876 0.0 -1.0 0.0
2019-03-05 64.39 66.3100 66.6844 -0.3744 0.0 0.0 -1.0
2019-04-25 64.14 65.1170 65.0770 0.0400 1.0 1.0 0.0
2019-04-26 65.15 65.1900 65.0612 0.1288 1.0 0.0 1.0
2019-05-07 66.40 64.9800 65.0014 -0.0214 0.0 -1.0 0.0
2019-05-08 66.07 64.9790 65.0172 -0.0382 0.0 0.0 -1.0
2019-05-20 65.86 65.3400 65.1998 0.1402 1.0 1.0 0.0
2019-05-21 66.52 65.5140 65.2434 0.2706 1.0 0.0 1.0
2019-06-05 64.44 65.1360 65.1892 -0.0532 0.0 -1.0 0.0
2019-06-06 63.73 65.0190 65.1790 -0.1600 0.0 0.0 -1.0
2019-06-17 67.10 65.3395 65.3154 0.0241 1.0 1.0 0.0
2019-06-18 68.20 65.4565 65.3286 0.1279 1.0 0.0 1.0
2019-08-05 63.36 66.3645 66.4552 -0.0907 0.0 -1.0 0.0
2019-08-06 63.98 66.1760 66.3970 -0.2210 0.0 0.0 -1.0
2019-09-23 65.73 65.1305 65.1196 0.0109 1.0 1.0 0.0
2019-09-24 64.56 65.2085 65.0494 0.1591 1.0 0.0 1.0
2019-10-09 61.98 64.1565 64.2004 -0.0439 0.0 -1.0 0.0
2019-10-10 63.26 64.0015 64.1552 -0.1537 0.0 0.0 -1.0
2019-11-05 65.39 64.5400 64.4560 0.0840 1.0 1.0 0.0
2019-11-06 65.41 64.7115 64.4980 0.2135 1.0 0.0 1.0
2019-11-20 64.88 64.4355 64.4408 -0.0053 0.0 -1.0 0.0
2019-11-21 65.73 64.4220 64.4282 -0.0062 0.0 0.0 -1.0
2019-11-22 65.26 64.5190 64.4030 0.1160 1.0 1.0 0.0
2019-11-25 67.22 64.6935 64.4298 0.2637 1.0 0.0 1.0
2020-01-14 64.20 65.6055 65.6890 -0.0835 0.0 -1.0 0.0
2020-01-15 64.10 65.5045 65.6778 -0.1733 0.0 0.0 -1.0
2020-02-18 67.01 65.7325 65.7048 0.0277 1.0 1.0 0.0
2020-02-19 67.35 65.9685 65.7332 0.2353 1.0 0.0 1.0
2020-05-29 77.83 76.5135 76.7346 -0.2211 0.0 -1.0 0.0
List the signal change and entry/exit points for GIS
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-25 43.29 41.2840 41.1012 0.1828 1.0 1.0 0.0
2019-01-28 43.55 41.5100 41.0586 0.4514 1.0 0.0 1.0
2019-10-16 52.65 54.1480 54.1652 -0.0172 0.0 -1.0 0.0
2019-10-17 52.96 54.0765 54.1660 -0.0895 0.0 0.0 -1.0
2019-12-04 53.30 52.8305 52.8172 0.0133 1.0 1.0 0.0
2019-12-05 53.90 52.9020 52.8118 0.0902 1.0 0.0 1.0
2020-01-09 52.38 52.5455 52.5462 -0.0007 0.0 -1.0 0.0
2020-01-10 52.25 52.5790 52.5820 -0.0030 0.0 0.0 -1.0
2020-01-13 53.06 52.6490 52.6290 0.0200 1.0 1.0 0.0
2020-01-14 53.00 52.7190 52.6718 0.0472 1.0 0.0 1.0
2020-02-26 52.14 52.9130 52.9536 -0.0406 0.0 -1.0 0.0
2020-02-27 50.14 52.7685 52.9244 -0.1559 0.0 0.0 -1.0
2020-03-11 52.87 52.9495 52.9420 0.0075 1.0 1.0 0.0
2020-03-12 50.00 52.8030 52.8872 -0.0842 0.0 -1.0 1.0
2020-03-13 53.48 52.8275 52.8856 -0.0581 0.0 0.0 -1.0
2020-03-17 59.67 53.1375 53.0652 0.0723 1.0 1.0 0.0
2020-03-18 57.75 53.3630 53.1684 0.1946 1.0 0.0 1.0
2020-03-23 47.28 52.9910 53.1032 -0.1122 0.0 -1.0 0.0
2020-03-24 48.23 52.7760 53.0228 -0.2468 0.0 0.0 -1.0
2020-03-31 52.77 52.8760 52.8096 0.0664 1.0 1.0 0.0
2020-04-01 53.12 52.8235 52.7852 0.0383 1.0 0.0 1.0
List the signal change and entry/exit points for GOLD
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-14 12.30 13.1115 13.1284 -0.0169 0.0 -1.0 0.0
2019-02-20 13.76 13.0265 13.0238 0.0027 1.0 1.0 0.0
2019-02-21 13.32 13.1040 13.0166 0.0874 1.0 0.0 1.0
2019-05-02 12.51 13.1510 13.1546 -0.0036 0.0 -1.0 0.0
2019-05-03 12.59 13.1025 13.1400 -0.0375 0.0 0.0 -1.0
2019-06-18 14.37 12.9630 12.8790 0.0840 1.0 1.0 0.0
2019-06-19 14.48 13.0810 12.8982 0.1828 1.0 0.0 1.0
2019-09-30 17.33 18.0080 18.0427 -0.0347 0.0 -1.0 0.0
2019-10-01 17.22 17.8980 18.0403 -0.1423 0.0 0.0 -1.0
2019-12-16 17.42 17.0135 16.9702 0.0433 1.0 1.0 0.0
2019-12-17 17.39 17.0385 16.9656 0.0729 1.0 0.0 1.0
2020-03-23 16.93 18.7265 18.7534 -0.0269 0.0 -1.0 0.0
2020-03-24 19.50 18.6390 18.7864 -0.1474 0.0 0.0 -1.0
2020-04-14 24.43 19.4385 19.4286 0.0099 1.0 1.0 0.0
2020-04-15 24.47 19.7765 19.5524 0.2241 1.0 0.0 1.0
List the signal change and entry/exit points for GOOG
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-22 1070.52 1052.6375 1052.1534 0.4841 1.0 1.0 0.0
2019-01-23 1075.57 1057.4390 1051.7970 5.6420 1.0 0.0 1.0
2019-05-17 1162.30 1195.5770 1197.8476 -2.2706 0.0 -1.0 0.0
2019-05-20 1138.85 1190.0775 1197.7782 -7.7007 0.0 0.0 -1.0
2019-07-17 1146.35 1117.8815 1116.3434 1.5381 1.0 1.0 0.0
2019-07-18 1146.33 1120.0815 1115.7880 4.2935 1.0 0.0 1.0
2020-03-09 1215.56 1421.5715 1426.4662 -4.8947 0.0 -1.0 0.0
2020-03-10 1280.39 1410.1570 1424.8660 -14.7090 0.0 0.0 -1.0
2020-04-30 1348.66 1240.5665 1238.5104 2.0561 1.0 1.0 0.0
2020-05-01 1320.61 1250.5550 1234.5596 15.9954 1.0 0.0 1.0
List the signal change and entry/exit points for GSK
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-31 39.20 38.8135 38.7804 0.0331 1.0 1.0 0.0
2019-02-01 39.20 38.8820 38.7576 0.1244 1.0 0.0 1.0
2019-05-01 40.41 40.7165 40.7544 -0.0379 0.0 -1.0 0.0
2019-05-02 40.46 40.6515 40.7364 -0.0849 0.0 0.0 -1.0
2019-06-27 39.96 39.8875 39.8632 0.0243 1.0 1.0 0.0
2019-06-28 40.02 39.9565 39.8640 0.0925 1.0 0.0 1.0
2019-08-23 41.19 40.7110 40.7536 -0.0426 0.0 -1.0 0.0
2019-08-26 41.29 40.6665 40.7770 -0.1105 0.0 0.0 -1.0
2019-09-06 42.09 41.0440 41.0106 0.0334 1.0 1.0 0.0
2019-09-09 41.48 41.0945 41.0410 0.0535 1.0 0.0 1.0
2020-02-12 44.23 46.3760 46.3914 -0.0154 0.0 -1.0 0.0
2020-02-13 43.78 46.1845 46.3684 -0.1839 0.0 0.0 -1.0
2020-04-27 42.63 39.7565 39.4814 0.2751 1.0 1.0 0.0
2020-04-28 42.09 39.9810 39.4484 0.5326 1.0 0.0 1.0
List the signal change and entry/exit points for HD
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-23 176.89 174.3660 174.2306 0.1354 1.0 1.0 0.0
2019-01-24 177.29 175.3235 174.0164 1.3071 1.0 0.0 1.0
2019-05-23 192.00 195.5280 196.0572 -0.5292 0.0 -1.0 0.0
2019-05-24 193.59 195.0270 196.2968 -1.2698 0.0 0.0 -1.0
2019-06-21 209.39 198.9100 198.7936 0.1164 1.0 1.0 0.0
2019-06-24 205.50 199.5055 198.8740 0.6315 1.0 0.0 1.0
2019-08-23 217.47 211.1690 211.3264 -0.1574 0.0 -1.0 0.0
2019-08-26 218.65 211.1995 211.5840 -0.3845 0.0 0.0 -1.0
2019-08-30 227.91 213.1675 212.8188 0.3487 1.0 1.0 0.0
2019-09-03 224.07 214.1240 213.1124 1.0116 1.0 0.0 1.0
2019-11-25 218.40 231.1675 231.2528 -0.0853 0.0 -1.0 0.0
2019-11-26 220.76 230.4985 231.0638 -0.5653 0.0 0.0 -1.0
2020-01-21 232.95 222.5120 222.1890 0.3230 1.0 1.0 0.0
2020-01-22 232.90 223.0975 222.1882 0.9093 1.0 0.0 1.0
2020-03-13 205.67 229.3745 230.1136 -0.7391 0.0 -1.0 0.0
2020-03-16 164.96 225.3710 229.0196 -3.6486 0.0 0.0 -1.0
2020-05-01 218.57 204.6655 203.3212 1.3443 1.0 1.0 0.0
2020-05-04 221.84 206.8225 202.8512 3.9713 1.0 0.0 1.0
List the signal change and entry/exit points for HRL
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-02-27 42.91 42.6590 42.5898 0.0692 1.0 1.0 0.0
2019-02-28 43.36 42.7505 42.5656 0.1849 1.0 0.0 1.0
2019-04-12 41.15 42.8235 42.8474 -0.0239 0.0 -1.0 0.0
2019-04-15 41.10 42.7510 42.8294 -0.0784 0.0 0.0 -1.0
2019-06-13 41.75 40.3785 40.3384 0.0401 1.0 1.0 0.0
2019-06-14 41.43 40.4590 40.3284 0.1306 1.0 0.0 1.0
2019-08-14 40.69 41.2375 41.2488 -0.0113 0.0 -1.0 0.0
2019-08-15 41.39 41.2175 41.2482 -0.0307 0.0 0.0 -1.0
2019-08-21 40.97 41.2350 41.2018 0.0332 1.0 1.0 0.0
2019-08-22 42.95 41.3410 41.2298 0.1112 1.0 0.0 1.0
2019-10-21 40.64 42.3760 42.4232 -0.0472 0.0 -1.0 0.0
2019-10-22 40.53 42.2545 42.3976 -0.1431 0.0 0.0 -1.0
2019-11-26 44.28 42.1035 42.1026 0.0009 1.0 1.0 0.0
2019-11-27 44.88 42.3030 42.1410 0.1620 1.0 0.0 1.0
2020-03-04 45.05 45.8280 45.8462 -0.0182 0.0 -1.0 0.0
2020-03-05 43.80 45.6485 45.8230 -0.1745 0.0 0.0 -1.0
2020-04-09 47.54 46.0090 45.6826 0.3264 1.0 1.0 0.0
2020-04-13 47.10 46.2440 45.6670 0.5770 1.0 0.0 1.0
2020-05-27 46.93 47.1720 47.1810 -0.0090 0.0 -1.0 0.0
2020-05-28 47.88 47.1860 47.1680 0.0180 1.0 1.0 -1.0
2020-05-29 48.83 47.2850 47.1792 0.1058 1.0 0.0 1.0
List the signal change and entry/exit points for JNJ
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-02-19 135.69 132.0650 132.02540 0.03960 1.0 1.0 0.0
2019-02-20 136.35 132.4425 131.83420 0.60830 1.0 0.0 1.0
2019-04-29 139.84 137.5740 137.61920 -0.04520 0.0 -1.0 0.0
2019-04-30 141.20 137.6850 137.71560 -0.03060 0.0 0.0 -1.0
2019-05-01 141.95 137.8970 137.84080 0.05620 1.0 1.0 0.0
2019-05-02 141.28 138.1025 137.93940 0.16310 1.0 0.0 1.0
2019-05-31 131.15 137.7495 137.96920 -0.21970 0.0 -1.0 0.0
2019-06-03 131.44 137.2210 137.83600 -0.61500 0.0 0.0 -1.0
2019-06-27 140.69 139.0735 138.85180 0.22170 1.0 1.0 0.0
2019-06-28 139.28 139.4800 138.86700 0.61300 1.0 0.0 1.0
2019-07-23 128.84 137.2545 137.63960 -0.38510 0.0 -1.0 0.0
2019-07-24 129.78 136.5315 137.49120 -0.95970 0.0 0.0 -1.0
2019-10-04 133.66 130.4105 130.37406 0.03644 1.0 1.0 0.0
2019-10-07 133.16 130.7210 130.42266 0.29834 1.0 0.0 1.0
2019-11-13 131.27 130.5932 130.60408 -0.01088 0.0 -1.0 0.0
2019-11-14 130.96 130.3327 130.65168 -0.31898 0.0 0.0 -1.0
2019-11-18 134.83 131.0352 130.94388 0.09132 1.0 1.0 0.0
2019-11-19 134.82 131.3162 131.04928 0.26692 1.0 0.0 1.0
2020-03-04 143.48 146.8940 147.09120 -0.19720 0.0 -1.0 0.0
2020-03-05 142.01 146.2950 147.01020 -0.71520 0.0 0.0 -1.0
2020-04-22 152.99 139.0310 138.73580 0.29520 1.0 1.0 0.0
2020-04-23 155.51 140.8365 138.80620 2.03030 1.0 0.0 1.0
List the signal change and entry/exit points for K
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-04-11 57.35 56.3825 56.3224 0.0601 1.0 1.0 0.0
2019-04-12 57.57 56.5475 56.2936 0.2539 1.0 0.0 1.0
2019-05-29 52.80 56.9515 57.2326 -0.2811 0.0 -1.0 0.0
2019-05-30 52.09 56.5865 57.1862 -0.5997 0.0 0.0 -1.0
2019-07-25 58.37 55.5630 55.5048 0.0582 1.0 1.0 0.0
2019-07-26 58.73 55.8400 55.5320 0.3080 1.0 0.0 1.0
2019-10-15 61.93 63.0385 63.0778 -0.0393 0.0 -1.0 0.0
2019-10-16 61.33 62.9245 63.0712 -0.1467 0.0 0.0 -1.0
2019-11-15 64.66 63.2065 63.1250 0.0815 1.0 1.0 0.0
2019-11-18 65.43 63.3530 63.1502 0.2028 1.0 0.0 1.0
2020-02-18 67.15 67.9235 68.0250 -0.1015 0.0 -1.0 0.0
2020-02-19 66.30 67.7085 68.0360 -0.3275 0.0 0.0 -1.0
2020-04-24 64.10 63.0095 62.8120 0.1975 1.0 1.0 0.0
2020-04-27 65.10 63.2910 62.7712 0.5198 1.0 0.0 1.0
List the signal change and entry/exit points for KR
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-02-13 28.96 28.4610 28.4248 0.0362 1.0 1.0 0.0
2019-02-14 28.96 28.4740 28.4108 0.0632 1.0 0.0 1.0
2019-03-11 24.67 28.2310 28.2356 -0.0046 0.0 -1.0 0.0
2019-03-12 24.48 28.0775 28.1776 -0.1001 0.0 0.0 -1.0
2019-05-07 25.77 25.4840 25.4352 0.0488 1.0 1.0 0.0
2019-05-08 25.28 25.5510 25.3624 0.1886 1.0 0.0 1.0
2019-05-30 22.78 24.6625 24.7598 -0.0973 0.0 -1.0 0.0
2019-05-31 22.81 24.5140 24.7362 -0.2222 0.0 0.0 -1.0
2019-08-21 23.34 22.3765 22.2782 0.0983 1.0 1.0 0.0
2019-08-22 23.67 22.5030 22.2590 0.2440 1.0 0.0 1.0
2019-10-25 25.28 24.6580 24.6738 -0.0158 0.0 -1.0 0.0
2019-10-28 25.33 24.6355 24.7272 -0.0917 0.0 0.0 -1.0
2019-11-08 27.02 25.1735 25.1728 0.0007 1.0 1.0 0.0
2019-11-11 26.61 25.2990 25.2314 0.0676 1.0 0.0 1.0
2020-02-05 28.08 28.0690 28.1132 -0.0442 0.0 -1.0 0.0
2020-02-06 28.05 28.0505 28.1332 -0.0827 0.0 0.0 -1.0
2020-02-27 28.36 28.5695 28.5490 0.0205 1.0 1.0 0.0
2020-02-28 28.13 28.5985 28.5454 0.0531 1.0 0.0 1.0
List the signal change and entry/exit points for LLY
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-11 116.18 112.5960 112.6720 -0.0760 0.0 -1.0 0.0
2019-01-16 116.80 113.2670 113.1506 0.1164 1.0 1.0 0.0
2019-01-17 119.16 113.9000 113.3988 0.5012 1.0 0.0 1.0
2019-04-24 118.00 124.1000 124.7348 -0.6348 0.0 -1.0 0.0
2019-04-25 118.23 123.5730 124.7096 -1.1366 0.0 0.0 -1.0
2019-08-26 111.78 111.3700 111.3214 0.0486 1.0 1.0 0.0
2019-08-27 110.73 111.4720 111.2680 0.2040 1.0 0.0 1.0
2019-10-04 108.20 111.4495 111.5232 -0.0737 0.0 -1.0 0.0
2019-10-07 107.83 111.2875 111.5144 -0.2269 0.0 0.0 -1.0
2019-11-12 113.17 111.1265 110.9724 0.1541 1.0 1.0 0.0
2019-11-13 112.79 111.3685 110.9632 0.4053 1.0 0.0 1.0
2020-03-09 135.72 138.2670 138.3374 -0.0704 0.0 -1.0 0.0
2020-03-10 141.19 138.0510 138.5384 -0.4874 0.0 0.0 -1.0
2020-04-17 157.29 139.2165 138.7748 0.4417 1.0 1.0 0.0
2020-04-20 157.79 140.9860 138.9846 2.0014 1.0 0.0 1.0
List the signal change and entry/exit points for LOGI
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-28 36.49 33.0275 32.9008 0.1267 1.0 1.0 0.0
2019-01-29 36.18 33.2790 32.9180 0.3610 1.0 0.0 1.0
2019-05-21 38.01 39.2145 39.3842 -0.1697 0.0 -1.0 0.0
2019-05-22 38.53 39.0745 39.4028 -0.3283 0.0 0.0 -1.0
2019-07-03 39.66 38.4775 38.4508 0.0267 1.0 1.0 0.0
2019-07-05 39.53 38.6185 38.4148 0.2037 1.0 0.0 1.0
2019-08-27 39.98 39.5325 39.5740 -0.0415 0.0 -1.0 0.0
2019-08-28 39.32 39.4365 39.6014 -0.1649 0.0 0.0 -1.0
2019-09-09 41.96 39.9400 39.9090 0.0310 1.0 1.0 0.0
2019-09-10 41.21 40.0615 39.9380 0.1235 1.0 0.0 1.0
2019-10-18 40.05 40.4190 40.4252 -0.0062 0.0 -1.0 0.0
2019-10-21 40.75 40.4460 40.4508 -0.0048 0.0 0.0 -1.0
2019-10-30 41.40 40.8085 40.7754 0.0331 1.0 1.0 0.0
2019-10-31 40.75 40.8345 40.7852 0.0493 1.0 0.0 1.0
2020-02-18 43.09 45.9565 46.1154 -0.1589 0.0 -1.0 0.0
2020-02-19 43.04 45.7190 46.1090 -0.3900 0.0 0.0 -1.0
2020-04-13 44.35 41.8735 41.7668 0.1067 1.0 1.0 0.0
2020-04-14 45.88 42.4730 41.7918 0.6812 1.0 0.0 1.0
List the signal change and entry/exit points for LVGO
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-11-11 25.88 21.95450 21.6550 0.29950 1.0 1.0 0.0
2019-11-12 25.60 22.26150 21.5624 0.69910 1.0 0.0 1.0
2020-01-09 26.30 25.83050 25.8726 -0.04210 0.0 -1.0 0.0
2020-01-10 27.00 25.80350 25.9758 -0.17230 0.0 0.0 -1.0
2020-01-27 25.72 27.06925 27.0443 0.02495 1.0 1.0 0.0
2020-01-28 25.87 27.15075 27.0275 0.12325 1.0 0.0 1.0
2020-02-13 27.09 26.34900 26.4562 -0.10720 0.0 -1.0 0.0
2020-02-14 27.17 26.22175 26.4644 -0.24265 0.0 0.0 -1.0
2020-03-05 28.42 26.47250 26.4388 0.03370 1.0 1.0 0.0
2020-03-06 27.84 26.58650 26.4642 0.12230 1.0 0.0 1.0
2020-03-12 24.21 26.46600 26.4998 -0.03380 0.0 -1.0 0.0
2020-03-13 25.27 26.37500 26.5040 -0.12900 0.0 0.0 -1.0
2020-04-13 35.27 26.36150 26.1819 0.17960 1.0 1.0 0.0
2020-04-14 37.45 27.22550 26.4477 0.77780 1.0 0.0 1.0
List the signal change and entry/exit points for MASI
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-22 120.39 109.3130 108.6618 0.6512 1.0 1.0 0.0
2019-01-23 120.49 110.2755 108.7208 1.5547 1.0 0.0 1.0
2019-04-29 129.21 132.1850 132.1870 -0.0020 0.0 -1.0 0.0
2019-04-30 130.15 131.7025 132.1976 -0.4951 0.0 0.0 -1.0
2019-05-17 140.77 134.7005 134.2304 0.4701 1.0 1.0 0.0
2019-05-20 138.50 135.4465 134.4274 1.0191 1.0 0.0 1.0
2019-08-28 152.50 151.1070 151.1898 -0.0828 0.0 -1.0 0.0
2019-08-29 154.20 151.1295 151.3616 -0.2321 0.0 0.0 -1.0
2019-11-22 153.35 147.3405 147.1820 0.1585 1.0 1.0 0.0
2019-11-25 153.73 147.7505 147.2514 0.4991 1.0 0.0 1.0
2020-03-20 155.10 173.1275 173.3750 -0.2475 0.0 -1.0 0.0
2020-03-23 148.38 171.8825 173.0900 -1.2075 0.0 0.0 -1.0
2020-04-16 205.03 177.8760 177.1876 0.6884 1.0 1.0 0.0
2020-04-17 199.70 179.6415 177.6762 1.9653 1.0 0.0 1.0
List the signal change and entry/exit points for MDLZ
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-02-01 45.57 42.9805 42.8508 0.1297 1.0 1.0 0.0
2019-02-04 46.11 43.2440 42.8844 0.3596 1.0 0.0 1.0
2019-08-09 54.69 54.3105 54.3694 -0.0589 0.0 -1.0 0.0
2019-08-12 54.25 54.2880 54.4374 -0.1494 0.0 0.0 -1.0
2019-09-05 56.14 54.6605 54.5750 0.0855 1.0 1.0 0.0
2019-09-06 56.63 54.7445 54.6184 0.1261 1.0 0.0 1.0
2019-10-22 52.71 54.6720 54.7284 -0.0564 0.0 -1.0 0.0
2019-10-23 52.65 54.5450 54.6900 -0.1450 0.0 0.0 -1.0
2019-12-17 54.09 53.1030 53.0886 0.0144 1.0 1.0 0.0
2019-12-18 54.53 53.1940 53.0880 0.1060 1.0 0.0 1.0
2020-03-13 50.92 55.7925 55.9292 -0.1367 0.0 -1.0 0.0
2020-03-16 45.10 55.0635 55.7446 -0.6811 0.0 0.0 -1.0
2020-04-30 51.44 52.0475 51.7760 0.2715 1.0 1.0 0.0
2020-05-01 50.70 52.0635 51.6092 0.4543 1.0 0.0 1.0
2020-05-29 52.12 50.2785 50.3338 -0.0553 0.0 -1.0 0.0
List the signal change and entry/exit points for MKC
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-03-11 139.08 133.1875 132.9366 0.2509 1.0 1.0 0.0
2019-03-12 138.40 133.7330 132.9038 0.8292 1.0 0.0 1.0
2019-09-19 160.03 161.0885 161.1690 -0.0805 0.0 -1.0 0.0
2019-09-20 160.14 160.9765 161.2318 -0.2553 0.0 0.0 -1.0
2019-10-11 164.76 162.5145 162.3780 0.1365 1.0 1.0 0.0
2019-10-14 163.01 162.7510 162.4546 0.2964 1.0 0.0 1.0
2019-11-05 159.02 161.6100 161.7220 -0.1120 0.0 -1.0 0.0
2019-11-06 159.32 161.2560 161.6478 -0.3918 0.0 0.0 -1.0
2019-11-21 166.43 161.9920 161.9744 0.0176 1.0 1.0 0.0
2019-11-22 166.91 162.3685 162.1702 0.1983 1.0 0.0 1.0
2020-01-29 167.41 168.5870 168.6280 -0.0410 0.0 -1.0 0.0
2020-01-30 165.51 168.3760 168.6906 -0.3146 0.0 0.0 -1.0
2020-04-23 151.62 148.1875 147.3720 0.8155 1.0 1.0 0.0
2020-04-24 154.26 149.3185 147.1564 2.1621 1.0 0.0 1.0
List the signal change and entry/exit points for MKTX
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-10 212.67 213.1630 213.8464 -0.6834 0.0 -1.0 0.0
2019-02-08 220.67 216.2140 215.9432 0.2708 1.0 1.0 0.0
2019-02-11 223.56 216.7625 216.0578 0.7047 1.0 0.0 1.0
2019-09-26 332.00 359.9740 361.6520 -1.6780 0.0 -1.0 0.0
2019-09-27 324.71 356.5970 360.6902 -4.0932 0.0 0.0 -1.0
2019-11-11 359.74 351.1375 350.3712 0.7663 1.0 1.0 0.0
2019-11-12 365.93 351.9680 349.6476 2.3204 1.0 0.0 1.0
2020-01-06 374.08 374.4815 374.9188 -0.4373 0.0 -1.0 0.0
2020-01-07 375.25 374.4490 375.4346 -0.9856 0.0 0.0 -1.0
2020-04-13 385.79 346.4025 345.6918 0.7107 1.0 1.0 0.0
2020-04-14 397.71 350.7235 346.5624 4.1611 1.0 0.0 1.0
List the signal change and entry/exit points for MRNA
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-02-20 19.92 17.26200 16.7430 0.51900 1.0 1.0 0.0
2019-02-21 19.34 17.48950 16.7578 0.73170 1.0 0.0 1.0
2019-05-31 20.78 23.21350 23.4134 -0.19990 0.0 -1.0 0.0
2019-06-03 19.85 22.84600 23.4236 -0.57760 0.0 0.0 -1.0
2019-09-04 15.42 13.98250 13.9770 0.00550 1.0 1.0 0.0
2019-09-05 15.53 14.11650 14.0122 0.10430 1.0 0.0 1.0
2019-10-21 15.50 15.19325 15.2799 -0.08665 0.0 -1.0 0.0
2019-10-22 15.92 15.09825 15.3379 -0.23965 0.0 0.0 -1.0
2019-11-08 17.49 16.10300 16.0909 0.01210 1.0 1.0 0.0
2019-11-11 17.40 16.27650 16.1243 0.15220 1.0 0.0 1.0
List the signal change and entry/exit points for MRVL
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-16 16.640 16.06100 15.9946 0.06640 1.0 1.0 0.0
2019-01-17 16.520 16.11500 15.9732 0.14180 1.0 0.0 1.0
2019-06-03 22.350 22.69450 22.6984 -0.00390 0.0 -1.0 0.0
2019-06-04 23.420 22.64400 22.7726 -0.12860 0.0 0.0 -1.0
2019-06-26 23.710 23.70050 23.6984 0.00210 1.0 1.0 0.0
2019-06-27 23.890 23.78550 23.6960 0.08950 1.0 0.0 1.0
2019-08-26 23.600 24.83400 24.9752 -0.14120 0.0 -1.0 0.0
2019-08-27 23.510 24.66600 24.9710 -0.30500 0.0 0.0 -1.0
2019-10-01 24.000 25.08475 25.0483 0.03645 1.0 1.0 0.0
2019-10-02 23.990 25.08275 24.9981 0.08465 1.0 0.0 1.0
2019-10-11 24.040 24.53700 24.5716 -0.03460 0.0 -1.0 0.0
2019-10-14 24.050 24.46950 24.5520 -0.08250 0.0 0.0 -1.0
2019-11-07 26.880 24.76800 24.6982 0.06980 1.0 1.0 0.0
2019-11-08 27.070 24.91950 24.7556 0.16390 1.0 0.0 1.0
2019-12-19 26.050 25.37700 25.3822 -0.00520 0.0 -1.0 0.0
2019-12-20 25.960 25.36800 25.4356 -0.06760 0.0 0.0 -1.0
2020-01-08 26.050 26.03800 25.9850 0.05300 1.0 1.0 0.0
2020-01-09 26.100 26.15900 26.0040 0.15500 1.0 0.0 1.0
2020-02-14 25.120 25.76400 25.8740 -0.11000 0.0 -1.0 0.0
2020-02-18 24.790 25.57900 25.8914 -0.31240 0.0 0.0 -1.0
2020-04-17 25.955 23.11675 22.8450 0.27175 1.0 1.0 0.0
2020-04-20 26.230 23.49475 22.8546 0.64015 1.0 0.0 1.0
List the signal change and entry/exit points for MSFT
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-02-04 105.74 104.7455 104.6508 0.0947 1.0 1.0 0.0
2019-02-05 107.22 105.0035 104.7610 0.2425 1.0 0.0 1.0
2019-08-23 133.39 136.7600 136.7826 -0.0226 0.0 -1.0 0.0
2019-08-26 135.45 136.4810 136.8426 -0.3616 0.0 0.0 -1.0
2019-09-23 139.14 137.6000 137.4492 0.1508 1.0 1.0 0.0
2019-09-24 137.38 137.6965 137.4188 0.2777 1.0 0.0 1.0
2020-03-13 158.83 167.5470 168.7680 -1.2210 0.0 -1.0 0.0
2020-03-16 135.42 165.0505 168.2640 -3.2135 0.0 0.0 -1.0
2020-04-22 173.52 163.7015 163.2920 0.4095 1.0 1.0 0.0
2020-04-23 171.42 164.9265 163.0316 1.8949 1.0 0.0 1.0
List the signal change and entry/exit points for NET
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-11-29 19.48 17.1390 17.0892 0.0498 1.0 1.0 0.0
2019-12-02 18.94 17.2445 17.0706 0.1739 1.0 0.0 1.0
List the signal change and entry/exit points for NFLX
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-15 354.64 285.80825 285.5963 0.21195 1.0 1.0 0.0
2019-01-16 351.39 290.23775 286.2765 3.96125 1.0 0.0 1.0
2019-05-23 352.21 363.56750 363.8106 -0.24310 0.0 -1.0 0.0
2019-05-24 354.39 362.54450 363.7220 -1.17750 0.0 0.0 -1.0
2019-07-03 381.72 360.91550 360.6294 0.28610 1.0 1.0 0.0
2019-07-05 380.55 362.08650 360.7558 1.33070 1.0 0.0 1.0
2019-07-29 332.70 353.41400 354.4572 -1.04320 0.0 -1.0 0.0
2019-07-30 325.93 350.98050 353.8868 -2.90630 0.0 0.0 -1.0
2019-11-05 288.03 281.48050 281.3116 0.16890 1.0 1.0 0.0
2019-11-06 288.59 282.53350 281.2628 1.27070 1.0 0.0 1.0
2020-03-19 332.03 354.11875 355.0503 -0.93155 0.0 -1.0 0.0
2020-03-20 332.83 351.75675 354.9217 -3.16495 0.0 0.0 -1.0
2020-04-15 426.75 366.69500 365.7543 0.94070 1.0 1.0 0.0
2020-04-16 439.17 372.88000 367.1575 5.72250 1.0 0.0 1.0
List the signal change and entry/exit points for NVDA
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-02-01 144.73 146.2695 145.8054 0.4641 1.0 1.0 0.0
2019-02-04 149.18 146.9190 145.8950 1.0240 1.0 0.0 1.0
2019-05-16 160.19 176.7380 177.4956 -0.7576 0.0 -1.0 0.0
2019-05-17 156.53 175.2495 177.6410 -2.3915 0.0 0.0 -1.0
2019-07-11 166.28 156.6445 156.0936 0.5509 1.0 1.0 0.0
2019-07-12 167.61 157.6120 155.8364 1.7756 1.0 0.0 1.0
2019-08-23 162.44 161.2135 161.8656 -0.6521 0.0 -1.0 0.0
2019-08-26 165.45 160.7450 162.2818 -1.5368 0.0 0.0 -1.0
2019-09-09 180.50 165.2250 165.1984 0.0266 1.0 1.0 0.0
2019-09-10 183.18 166.8115 165.5774 1.2341 1.0 0.0 1.0
2020-03-19 212.97 251.2740 254.8303 -3.5563 0.0 -1.0 0.0
2020-03-20 205.75 246.8580 254.1377 -7.2797 0.0 0.0 -1.0
2020-04-20 287.05 262.7570 260.4380 2.3190 1.0 1.0 0.0
2020-04-21 269.51 265.5980 260.7964 4.8016 1.0 0.0 1.0
List the signal change and entry/exit points for OKTA
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-03-28 81.31 81.4960 81.5168 -0.0208 0.0 -1.0 0.0
2019-04-03 89.35 82.2970 82.2712 0.0258 1.0 1.0 0.0
2019-04-04 85.39 82.5060 82.4136 0.0924 1.0 0.0 1.0
2019-08-23 132.46 131.3545 131.3832 -0.0287 0.0 -1.0 0.0
2019-08-26 133.44 131.3950 131.4730 -0.0780 0.0 0.0 -1.0
2019-11-15 117.52 108.8055 108.0094 0.7961 1.0 1.0 0.0
2019-11-18 121.15 109.8050 108.2472 1.5578 1.0 0.0 1.0
2020-03-12 106.08 127.8690 127.9890 -0.1200 0.0 -1.0 0.0
2020-03-13 107.29 126.4680 127.8274 -1.3594 0.0 0.0 -1.0
2020-04-17 148.09 127.3220 126.1160 1.2060 1.0 1.0 0.0
2020-04-20 152.60 129.1795 126.5662 2.6133 1.0 0.0 1.0
List the signal change and entry/exit points for PANW
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-05-15 219.75 240.0010 240.8674 -0.8664 0.0 -1.0 0.0
2019-07-22 221.59 211.8910 211.4574 0.4336 1.0 1.0 0.0
2019-07-23 223.95 213.1630 211.2374 1.9256 1.0 0.0 1.0
2019-08-26 203.65 212.6300 212.9214 -0.2914 0.0 -1.0 0.0
2019-08-27 202.08 211.3450 212.8630 -1.5180 0.0 0.0 -1.0
2019-10-11 210.42 208.8850 208.6450 0.2400 1.0 1.0 0.0
2019-10-14 213.55 208.7725 208.4848 0.2877 1.0 0.0 1.0
2019-12-20 230.01 229.0250 229.2350 -0.2100 0.0 -1.0 0.0
2019-12-23 231.33 228.2480 229.6532 -1.4052 0.0 0.0 -1.0
2020-01-15 240.70 235.2040 234.8136 0.3904 1.0 1.0 0.0
2020-01-16 243.26 235.8335 234.9984 0.8351 1.0 0.0 1.0
2020-02-27 187.56 235.7960 236.4860 -0.6900 0.0 -1.0 0.0
2020-02-28 184.62 233.1270 235.5846 -2.4576 0.0 0.0 -1.0
2020-04-27 196.88 180.8360 180.7562 0.0798 1.0 1.0 0.0
2020-04-28 193.55 182.1900 179.6822 2.5078 1.0 0.0 1.0
List the signal change and entry/exit points for PEP
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-02-15 115.91 111.87925 111.5125 0.36675 1.0 1.0 0.0
2019-02-19 115.93 112.17225 111.4751 0.69715 1.0 0.0 1.0
2019-08-01 127.14 131.52300 131.5966 -0.07360 0.0 -1.0 0.0
2019-08-02 127.92 131.26800 131.5536 -0.28560 0.0 0.0 -1.0
2019-09-03 137.46 131.79900 131.6028 0.19620 1.0 1.0 0.0
2019-09-04 139.15 132.43400 131.7030 0.73100 1.0 0.0 1.0
2019-11-07 133.32 136.31950 136.4574 -0.13790 0.0 -1.0 0.0
2019-11-08 133.13 136.09400 136.3996 -0.30560 0.0 0.0 -1.0
2019-12-17 136.17 135.93900 135.8028 0.13620 1.0 1.0 0.0
2019-12-18 135.97 136.00900 135.7774 0.23160 1.0 0.0 1.0
2020-03-11 129.75 140.03800 140.1751 -0.13710 0.0 -1.0 0.0
2020-03-12 115.34 138.50100 139.7457 -1.24470 0.0 0.0 -1.0
2020-04-27 134.46 130.73650 130.4194 0.31710 1.0 1.0 0.0
2020-04-28 136.32 131.27850 130.2060 1.07250 1.0 0.0 1.0
List the signal change and entry/exit points for PFE
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-02-27 42.93 42.3135 42.3128 0.0007 1.0 1.0 0.0
2019-02-28 43.35 42.4020 42.3038 0.0982 1.0 0.0 1.0
2019-03-28 42.29 42.0385 42.0764 -0.0379 0.0 -1.0 0.0
2019-03-29 42.47 41.9940 42.0836 -0.0896 0.0 0.0 -1.0
2019-04-05 42.99 42.2050 42.1624 0.0426 1.0 1.0 0.0
2019-04-08 43.14 42.2870 42.2124 0.0746 1.0 0.0 1.0
2019-04-18 39.38 42.1110 42.1670 -0.0560 0.0 -1.0 0.0
2019-04-22 38.98 41.9675 42.1126 -0.1451 0.0 0.0 -1.0
2019-06-04 42.23 41.4470 41.4336 0.0134 1.0 1.0 0.0
2019-06-05 42.48 41.5295 41.4454 0.0841 1.0 0.0 1.0
2019-07-31 38.84 42.6120 42.7024 -0.0904 0.0 -1.0 0.0
2019-08-01 38.25 42.3045 42.6340 -0.3295 0.0 0.0 -1.0
2019-10-07 35.83 36.2655 36.1851 0.0804 1.0 1.0 0.0
2019-10-08 35.43 36.1680 36.0647 0.1033 1.0 0.0 1.0
2020-02-12 37.74 38.8180 38.8440 -0.0260 0.0 -1.0 0.0
2020-02-13 36.93 38.6310 38.8168 -0.1858 0.0 0.0 -1.0
2020-04-22 36.25 34.1215 33.9658 0.1557 1.0 1.0 0.0
2020-04-23 36.69 34.4685 33.9378 0.5307 1.0 0.0 1.0
List the signal change and entry/exit points for PG
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-10 91.17 91.9905 92.0662 -0.0757 0.0 -1.0 0.0
2019-02-01 97.47 92.8125 92.5956 0.2169 1.0 1.0 0.0
2019-02-04 98.03 93.0895 92.6904 0.3991 1.0 0.0 1.0
2019-10-25 123.25 121.2505 121.3110 -0.0605 0.0 -1.0 0.0
2019-10-28 123.48 121.2055 121.3970 -0.1915 0.0 0.0 -1.0
2019-11-18 121.89 121.6705 121.5286 0.1419 1.0 1.0 0.0
2019-11-19 121.42 121.6325 121.5594 0.0731 1.0 0.0 1.0
2019-11-21 120.34 121.3745 121.5312 -0.1567 0.0 -1.0 0.0
2019-11-22 120.29 121.2265 121.4946 -0.2681 0.0 0.0 -1.0
2019-12-09 124.87 121.8495 121.6002 0.2493 1.0 1.0 0.0
2019-12-10 124.27 122.0965 121.5980 0.4985 1.0 0.0 1.0
2020-02-27 113.50 124.4115 124.6514 -0.2399 0.0 -1.0 0.0
2020-02-28 113.23 123.7755 124.4048 -0.6293 0.0 0.0 -1.0
2020-04-24 118.78 116.8250 116.3832 0.4418 1.0 1.0 0.0
2020-04-27 117.45 117.1890 116.2330 0.9560 1.0 0.0 1.0
List the signal change and entry/exit points for PLD
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-02-01 69.41 64.1770 63.8376 0.3394 1.0 1.0 0.0
2019-02-04 69.65 64.7595 63.8766 0.8829 1.0 0.0 1.0
2019-12-30 88.86 89.2180 89.2466 -0.0286 0.0 -1.0 0.0
2019-12-31 89.14 89.1745 89.2372 -0.0627 0.0 0.0 -1.0
2020-01-21 95.57 89.9525 89.7886 0.1639 1.0 1.0 0.0
2020-01-22 93.94 90.2480 89.9222 0.3258 1.0 0.0 1.0
2020-03-10 80.86 91.8750 92.1104 -0.2354 0.0 -1.0 0.0
2020-03-11 73.69 90.7490 91.8108 -1.0618 0.0 0.0 -1.0
2020-04-23 86.75 83.7100 83.4578 0.2522 1.0 1.0 0.0
2020-04-24 89.04 84.2775 83.3028 0.9747 1.0 0.0 1.0
List the signal change and entry/exit points for PRGO
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-02-21 48.32 47.17600 46.9366 0.23940 1.0 1.0 0.0
2019-02-22 48.94 47.37950 46.7386 0.64090 1.0 0.0 1.0
2019-05-29 45.36 49.15500 49.2024 -0.04740 0.0 -1.0 0.0
2019-05-30 43.08 48.88250 49.0792 -0.19670 0.0 0.0 -1.0
2019-07-12 51.76 47.29050 47.1834 0.10710 1.0 1.0 0.0
2019-07-15 51.50 47.70650 47.2318 0.47470 1.0 0.0 1.0
2019-08-26 46.56 48.75725 49.1037 -0.34645 0.0 -1.0 0.0
2019-08-27 45.43 48.31675 49.1373 -0.82055 0.0 0.0 -1.0
2019-09-19 54.30 50.51600 50.4937 0.02230 1.0 1.0 0.0
2019-09-20 55.24 50.88950 50.5841 0.30540 1.0 0.0 1.0
2019-11-11 49.10 53.16350 53.2660 -0.10250 0.0 -1.0 0.0
2019-11-12 48.29 52.88750 53.3074 -0.41990 0.0 0.0 -1.0
2019-12-20 54.72 52.36650 52.1240 0.24250 1.0 1.0 0.0
2019-12-23 53.94 52.61300 52.1340 0.47900 1.0 0.0 1.0
2020-03-11 46.04 55.56900 55.8798 -0.31080 0.0 -1.0 0.0
2020-03-12 40.66 54.61450 55.6626 -1.04810 0.0 0.0 -1.0
2020-04-30 53.30 50.22000 50.0450 0.17500 1.0 1.0 0.0
2020-05-01 52.68 50.71400 49.9064 0.80760 1.0 0.0 1.0
List the signal change and entry/exit points for PTON
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-12-05 31.31 29.2790 25.5907 3.6883 1.0 1.0 0.0
2019-12-06 32.63 29.7790 25.7281 4.0509 1.0 0.0 1.0
2020-01-16 30.83 29.3900 29.5600 -0.1700 0.0 -1.0 0.0
2020-01-17 31.70 29.3805 29.7392 -0.3587 0.0 0.0 -1.0
2020-02-11 28.65 30.9360 30.8764 0.0596 1.0 1.0 0.0
2020-02-12 28.34 30.8685 30.7386 0.1299 1.0 0.0 1.0
2020-02-19 27.10 30.1335 30.2606 -0.1271 0.0 -1.0 0.0
2020-02-20 26.98 29.9485 30.1476 -0.1991 0.0 0.0 -1.0
2020-04-15 35.61 27.3515 26.9213 0.4302 1.0 1.0 0.0
2020-04-16 36.35 27.8795 26.9789 0.9006 1.0 0.0 1.0
List the signal change and entry/exit points for PYPL
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-03 82.09 83.83900 83.8990 -0.06000 0.0 -1.0 0.0
2019-01-04 86.27 83.94300 83.9158 0.02720 1.0 1.0 0.0
2019-01-07 86.93 83.99850 83.9030 0.09550 1.0 0.0 1.0
2019-08-08 106.79 114.13450 114.6286 -0.49410 0.0 -1.0 0.0
2019-08-09 104.82 113.36950 114.4968 -1.12730 0.0 0.0 -1.0
2019-11-19 104.95 103.28000 103.1700 0.11000 1.0 1.0 0.0
2019-11-20 104.09 103.65250 103.1714 0.48110 1.0 0.0 1.0
2020-03-10 109.74 114.62000 114.6382 -0.01820 0.0 -1.0 0.0
2020-03-11 103.90 113.87300 114.5282 -0.65520 0.0 0.0 -1.0
2020-04-28 116.14 106.83725 105.8215 1.01575 1.0 1.0 0.0
2020-04-29 123.58 108.22925 105.8477 2.38155 1.0 0.0 1.0
List the signal change and entry/exit points for REGN
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-03-26 405.62 414.3130 414.9672 -0.6542 0.0 -1.0 0.0
2019-10-22 301.31 290.0830 289.7762 0.3068 1.0 1.0 0.0
2019-10-23 305.02 291.0015 289.7794 1.2221 1.0 0.0 1.0
2020-01-30 336.18 367.3575 367.4458 -0.0883 0.0 -1.0 0.0
2020-01-31 337.94 365.5870 367.4008 -1.8138 0.0 0.0 -1.0
2020-02-24 425.38 377.5810 375.4932 2.0878 1.0 1.0 0.0
2020-02-25 442.35 382.7275 376.8696 5.8579 1.0 0.0 1.0
List the signal change and entry/exit points for RMD
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-31 95.17 109.3300 109.3566 -0.0266 0.0 -1.0 0.0
2019-03-29 103.97 101.0865 101.0438 0.0427 1.0 1.0 0.0
2019-04-01 104.67 101.2250 100.7890 0.4360 1.0 0.0 1.0
2019-10-04 132.40 133.5095 133.5604 -0.0509 0.0 -1.0 0.0
2019-10-07 132.18 133.3630 133.6666 -0.3036 0.0 0.0 -1.0
2019-11-01 147.43 134.9435 134.8656 0.0779 1.0 1.0 0.0
2019-11-04 147.49 135.7090 135.1718 0.5372 1.0 0.0 1.0
2020-03-16 137.93 163.1890 163.4670 -0.2780 0.0 -1.0 0.0
2020-03-17 161.43 162.5205 163.5898 -1.0693 0.0 0.0 -1.0
2020-04-27 162.77 157.3205 156.6202 0.7003 1.0 1.0 0.0
2020-04-28 158.22 157.5210 156.2526 1.2684 1.0 0.0 1.0
List the signal change and entry/exit points for RNG
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-06-27 114.45 117.4300 117.4708 -0.0408 0.0 -1.0 0.0
2019-07-24 124.94 119.7150 119.4418 0.2732 1.0 1.0 0.0
2019-07-25 123.00 120.3190 119.5380 0.7810 1.0 0.0 1.0
2019-09-24 127.26 133.7620 133.7742 -0.0122 0.0 -1.0 0.0
2019-09-25 128.06 133.0270 133.9012 -0.8742 0.0 0.0 -1.0
2019-10-10 174.45 138.7750 138.1436 0.6314 1.0 1.0 0.0
2019-10-11 173.44 141.0895 138.7928 2.2967 1.0 0.0 1.0
2020-03-20 183.86 206.4340 208.1486 -1.7146 0.0 -1.0 0.0
2020-03-23 191.59 204.3060 208.2930 -3.9870 0.0 0.0 -1.0
2020-04-20 253.11 218.2995 216.7270 1.5725 1.0 1.0 0.0
2020-04-21 234.58 220.4490 217.2692 3.1798 1.0 0.0 1.0
List the signal change and entry/exit points for SHOP
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-03 129.79 139.4920 140.1106 -0.6186 0.0 -1.0 0.0
2019-01-23 156.60 144.2935 143.9162 0.3773 1.0 1.0 0.0
2019-01-24 158.41 146.2590 144.0936 2.1654 1.0 0.0 1.0
2019-09-26 313.14 346.5945 350.0158 -3.4213 0.0 -1.0 0.0
2019-09-27 305.69 342.2935 349.5066 -7.2131 0.0 0.0 -1.0
2019-12-04 372.00 319.8920 318.6318 1.2602 1.0 1.0 0.0
2019-12-05 363.59 323.3205 319.6116 3.7089 1.0 0.0 1.0
2020-03-17 355.09 455.7310 463.0472 -7.3162 0.0 -1.0 0.0
2020-03-18 336.83 445.4120 461.5172 -16.1052 0.0 0.0 -1.0
2020-04-22 626.56 462.6980 456.2792 6.4188 1.0 1.0 0.0
2020-04-23 620.49 471.3925 458.8340 12.5585 1.0 0.0 1.0
List the signal change and entry/exit points for SJM
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-31 104.88 101.7770 101.6224 0.1546 1.0 1.0 0.0
2019-02-01 103.83 102.2390 101.4378 0.8012 1.0 0.0 1.0
2019-06-20 121.10 123.1825 123.2868 -0.1043 0.0 -1.0 0.0
2019-06-21 121.52 122.9015 123.3358 -0.4343 0.0 0.0 -1.0
2019-11-04 106.92 107.1520 107.0962 0.0558 1.0 1.0 0.0
2019-11-05 107.44 107.2265 106.9864 0.2401 1.0 0.0 1.0
2019-11-11 104.43 107.1735 107.1886 -0.0151 0.0 -1.0 0.0
2019-11-12 105.13 107.0635 107.1516 -0.0881 0.0 0.0 -1.0
2020-01-28 106.27 104.9415 104.8448 0.0967 1.0 1.0 0.0
2020-01-29 105.18 105.0430 104.8586 0.1844 1.0 0.0 1.0
2020-03-25 105.19 107.2780 107.4496 -0.1716 0.0 -1.0 0.0
2020-03-26 103.47 107.1460 107.4310 -0.2850 0.0 0.0 -1.0
2020-04-08 114.13 108.4775 108.2274 0.2501 1.0 1.0 0.0
2020-04-09 112.75 109.1515 108.3788 0.7727 1.0 0.0 1.0
List the signal change and entry/exit points for SNY
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-03-15 45.09 42.6020 42.4890 0.1130 1.0 1.0 0.0
2019-03-18 44.91 42.7200 42.5384 0.1816 1.0 0.0 1.0
2019-04-25 41.21 42.9885 43.0414 -0.0529 0.0 -1.0 0.0
2019-04-26 42.62 42.9065 43.0614 -0.1549 0.0 0.0 -1.0
2019-06-19 44.08 42.2460 42.1828 0.0632 1.0 1.0 0.0
2019-06-20 43.94 42.3385 42.1808 0.1577 1.0 0.0 1.0
2019-07-30 42.07 42.4935 42.5182 -0.0247 0.0 -1.0 0.0
2019-07-31 41.70 42.3930 42.5236 -0.1306 0.0 0.0 -1.0
2019-09-04 44.73 42.5225 42.4560 0.0665 1.0 1.0 0.0
2019-09-05 44.78 42.7210 42.4818 0.2392 1.0 0.0 1.0
2020-02-14 49.93 49.6470 49.7932 -0.1462 0.0 -1.0 0.0
2020-02-18 51.14 49.6420 49.8838 -0.2418 0.0 0.0 -1.0
2020-04-27 50.63 46.2160 45.9494 0.2666 1.0 1.0 0.0
2020-04-28 49.87 46.4750 45.9482 0.5268 1.0 0.0 1.0
List the signal change and entry/exit points for SPGI
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-24 188.57 176.7750 175.3140 1.4610 1.0 1.0 0.0
2019-01-25 189.31 177.9945 175.3748 2.6197 1.0 0.0 1.0
2019-06-03 212.97 214.3300 214.3318 -0.0018 0.0 -1.0 0.0
2019-06-04 214.83 214.0910 214.5186 -0.4276 0.0 0.0 -1.0
2019-06-10 227.13 215.9560 215.9206 0.0354 1.0 1.0 0.0
2019-06-11 222.69 216.6565 216.1634 0.4931 1.0 0.0 1.0
2019-10-02 236.44 252.7450 253.3718 -0.6268 0.0 -1.0 0.0
2019-10-03 239.62 251.4845 253.3024 -1.8179 0.0 0.0 -1.0
2019-11-07 255.59 252.2765 252.2098 0.0667 1.0 1.0 0.0
2019-11-08 255.30 252.3920 252.1008 0.2912 1.0 0.0 1.0
2020-03-09 242.51 288.2130 289.1096 -0.8966 0.0 -1.0 0.0
2020-03-10 259.17 286.3435 288.8218 -2.4783 0.0 0.0 -1.0
2020-04-24 283.94 263.2645 260.9290 2.3355 1.0 1.0 0.0
2020-04-27 291.19 265.8365 260.7258 5.1107 1.0 0.0 1.0
List the signal change and entry/exit points for SPLK
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-03-27 120.490 126.76950 127.2800 -0.51050 0.0 -1.0 0.0
2019-04-25 135.760 130.29650 129.8398 0.45670 1.0 1.0 0.0
2019-04-26 137.700 131.09000 129.9176 1.17240 1.0 0.0 1.0
2019-05-31 113.990 129.83850 130.2612 -0.42270 0.0 -1.0 0.0
2019-06-03 109.050 128.53000 129.7928 -1.26280 0.0 0.0 -1.0
2019-07-12 136.820 126.14200 125.5260 0.61600 1.0 1.0 0.0
2019-07-15 138.490 127.15450 125.6064 1.54810 1.0 0.0 1.0
2019-08-22 118.410 128.69950 129.2066 -0.50710 0.0 -1.0 0.0
2019-08-23 118.560 127.59100 129.2130 -1.62200 0.0 0.0 -1.0
2019-10-11 120.810 119.00600 118.9754 0.03060 1.0 1.0 0.0
2019-10-14 119.680 119.24900 118.8396 0.40940 1.0 0.0 1.0
2019-10-21 111.130 117.59050 117.6782 -0.08770 0.0 -1.0 0.0
2019-10-22 110.460 117.16700 117.3050 -0.13800 0.0 0.0 -1.0
2019-10-23 115.000 117.04000 116.9706 0.06940 1.0 1.0 0.0
2019-10-24 119.690 117.04600 116.8524 0.19360 1.0 0.0 1.0
2020-03-10 132.280 156.59650 156.7817 -0.18520 0.0 -1.0 0.0
2020-03-11 120.740 154.22850 156.1663 -1.93780 0.0 0.0 -1.0
2020-05-04 134.920 130.39475 128.4235 1.97125 1.0 1.0 0.0
2020-05-05 143.615 131.65550 128.0948 3.56070 1.0 0.0 1.0
List the signal change and entry/exit points for SPOT
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-30 136.47 126.9320 126.9280 0.0040 1.0 1.0 0.0
2019-01-31 135.45 128.0175 126.8978 1.1197 1.0 0.0 1.0
2019-04-08 142.28 140.9020 141.1094 -0.2074 0.0 -1.0 0.0
2019-04-09 141.34 140.7025 141.2712 -0.5687 0.0 0.0 -1.0
2019-06-21 148.31 136.9220 136.1528 0.7692 1.0 1.0 0.0
2019-06-24 150.04 138.1915 136.3176 1.8739 1.0 0.0 1.0
2019-08-27 133.88 148.4355 148.5562 -0.1207 0.0 -1.0 0.0
2019-08-28 132.67 147.3220 148.2694 -0.9474 0.0 0.0 -1.0
2019-11-05 150.37 126.6435 125.6518 0.9917 1.0 1.0 0.0
2019-11-06 148.48 128.3555 125.9438 2.4117 1.0 0.0 1.0
2020-02-06 154.37 148.7875 148.8600 -0.0725 0.0 -1.0 0.0
2020-02-07 154.55 148.6280 149.1136 -0.4856 0.0 0.0 -1.0
2020-04-29 155.78 134.7670 133.9516 0.8154 1.0 1.0 0.0
2020-04-30 151.57 136.2650 134.1158 2.1492 1.0 0.0 1.0
List the signal change and entry/exit points for SQ
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-25 77.97 64.2495 64.0276 0.2219 1.0 1.0 0.0
2019-01-28 76.22 65.2530 64.1554 1.0976 1.0 0.0 1.0
2019-04-12 75.28 75.2595 75.3952 -0.1357 0.0 -1.0 0.0
2019-04-15 74.39 75.2175 75.4670 -0.2495 0.0 0.0 -1.0
2019-06-26 69.95 69.0040 68.5914 0.4126 1.0 1.0 0.0
2019-06-27 71.28 69.3845 68.5472 0.8373 1.0 0.0 1.0
2019-08-14 61.55 73.1745 73.3720 -0.1975 0.0 -1.0 0.0
2019-08-15 62.00 72.2215 73.3134 -1.0919 0.0 0.0 -1.0
2019-10-21 61.15 61.4440 61.3830 0.0610 1.0 1.0 0.0
2019-10-22 58.83 61.5105 61.3138 0.1967 1.0 0.0 1.0
2020-01-06 62.57 64.5520 64.6494 -0.0974 0.0 -1.0 0.0
2020-01-07 64.59 64.3825 64.7068 -0.3243 0.0 0.0 -1.0
2020-01-22 68.69 65.9775 65.9694 0.0081 1.0 1.0 0.0
2020-01-23 69.29 66.3020 66.1062 0.1958 1.0 0.0 1.0
2020-03-17 44.73 71.5925 72.8098 -1.2173 0.0 -1.0 0.0
2020-03-18 39.50 69.3055 72.3484 -3.0429 0.0 0.0 -1.0
2020-05-04 63.69 60.2375 59.8326 0.4049 1.0 1.0 0.0
2020-05-05 66.69 61.0510 59.5622 1.4888 1.0 0.0 1.0
List the signal change and entry/exit points for TDOC
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-25 63.00 55.4655 55.0792 0.3863 1.0 1.0 0.0
2019-01-28 62.04 56.1510 55.1088 1.0422 1.0 0.0 1.0
2019-03-22 58.77 62.7295 63.0200 -0.2905 0.0 -1.0 0.0
2019-03-25 55.66 62.0135 63.0222 -1.0087 0.0 0.0 -1.0
2019-05-15 59.10 57.7485 57.5510 0.1975 1.0 1.0 0.0
2019-05-16 61.48 58.3295 57.5774 0.7521 1.0 0.0 1.0
2019-08-21 60.61 65.3245 65.5340 -0.2095 0.0 -1.0 0.0
2019-08-22 59.78 64.9730 65.5748 -0.6018 0.0 0.0 -1.0
2019-09-25 69.00 65.1430 64.9690 0.1740 1.0 1.0 0.0
2019-09-26 68.54 65.7750 64.9710 0.8040 1.0 0.0 1.0
List the signal change and entry/exit points for TGT
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-29 71.70 69.21700 69.0668 0.15020 1.0 1.0 0.0
2019-01-30 72.33 69.52900 68.8508 0.67820 1.0 0.0 1.0
2019-05-13 71.68 78.34600 78.4604 -0.11440 0.0 -1.0 0.0
2019-05-14 71.26 77.81000 78.4322 -0.62220 0.0 0.0 -1.0
2019-06-11 87.85 79.49000 79.2460 0.24400 1.0 1.0 0.0
2019-06-12 88.26 80.34000 79.4118 0.92820 1.0 0.0 1.0
2019-08-08 83.80 86.09550 86.2592 -0.16370 0.0 -1.0 0.0
2019-08-09 82.41 85.83950 86.2996 -0.46010 0.0 0.0 -1.0
2019-08-26 104.77 87.74125 87.4513 0.28995 1.0 1.0 0.0
2019-08-27 104.70 88.63225 87.8025 0.82975 1.0 0.0 1.0
2020-01-24 114.32 122.11000 122.8504 -0.74040 0.0 -1.0 0.0
2020-01-27 115.78 121.45450 122.9990 -1.54450 0.0 0.0 -1.0
2020-04-29 112.10 104.86000 104.1416 0.71840 1.0 1.0 0.0
2020-04-30 109.74 105.58350 103.9886 1.59490 1.0 0.0 1.0
List the signal change and entry/exit points for TMO
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-30 245.06 234.5390 234.2724 0.2666 1.0 1.0 0.0
2019-01-31 245.67 235.8515 234.4320 1.4195 1.0 0.0 1.0
2019-05-24 271.80 270.2635 270.3200 -0.0565 0.0 -1.0 0.0
2019-05-28 266.38 269.9565 270.3858 -0.4293 0.0 0.0 -1.0
2019-06-13 286.24 272.1930 271.8236 0.3694 1.0 1.0 0.0
2019-06-14 285.26 273.1050 271.9936 1.1114 1.0 0.0 1.0
2019-08-07 274.79 285.2970 286.3896 -1.0926 0.0 -1.0 0.0
2019-08-08 280.50 284.5445 286.7044 -2.1599 0.0 0.0 -1.0
2019-09-16 295.33 284.8580 284.3462 0.5118 1.0 1.0 0.0
2019-09-17 292.71 285.5175 284.2442 1.2733 1.0 0.0 1.0
2019-10-21 283.54 283.7215 284.1480 -0.4265 0.0 -1.0 0.0
2019-10-22 280.99 283.5130 284.3278 -0.8148 0.0 0.0 -1.0
2019-10-30 301.86 287.1120 287.0666 0.0454 1.0 1.0 0.0
2019-10-31 301.98 288.0655 287.5408 0.5247 1.0 0.0 1.0
2020-02-26 309.16 328.6530 328.6958 -0.0428 0.0 -1.0 0.0
2020-02-27 297.08 326.8125 328.2274 -1.4149 0.0 0.0 -1.0
2020-04-23 320.51 306.3470 306.0794 0.2676 1.0 1.0 0.0
2020-04-24 328.70 308.6245 305.9620 2.6625 1.0 0.0 1.0
List the signal change and entry/exit points for TTD
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-04 117.92 123.1865 123.4102 -0.2237 0.0 -1.0 0.0
2019-01-28 135.69 127.5245 126.9712 0.5533 1.0 1.0 0.0
2019-01-29 134.56 128.5300 127.4212 1.1088 1.0 0.0 1.0
2019-05-30 201.89 202.5290 203.2136 -0.6846 0.0 -1.0 0.0
2019-05-31 198.81 201.2115 203.0706 -1.8591 0.0 0.0 -1.0
2019-06-11 249.36 210.5450 208.4480 2.0970 1.0 1.0 0.0
2019-06-12 242.20 213.3920 209.1694 4.2226 1.0 0.0 1.0
2019-09-09 213.67 246.4300 248.1870 -1.7570 0.0 -1.0 0.0
2019-09-10 210.06 244.1790 247.8326 -3.6536 0.0 0.0 -1.0
2019-11-13 228.85 203.2160 202.3618 0.8542 1.0 1.0 0.0
2019-11-14 228.08 204.5455 202.0492 2.4963 1.0 0.0 1.0
2020-03-11 223.94 277.7900 279.6618 -1.8718 0.0 -1.0 0.0
2020-03-12 192.65 272.1830 278.4604 -6.2774 0.0 0.0 -1.0
2020-04-30 292.58 228.3665 226.5346 1.8319 1.0 1.0 0.0
2020-05-01 278.90 234.0725 225.8836 8.1889 1.0 0.0 1.0
List the signal change and entry/exit points for TTWO
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-02-01 104.95 105.0090 104.9206 0.0884 1.0 1.0 0.0
2019-02-04 106.30 105.2390 104.9266 0.3124 1.0 0.0 1.0
2019-02-06 92.53 104.6135 104.6918 -0.0783 0.0 -1.0 0.0
2019-02-07 96.39 104.0600 104.5096 -0.4496 0.0 0.0 -1.0
2019-04-04 93.70 94.6110 94.3326 0.2784 1.0 1.0 0.0
2019-04-05 94.53 94.9855 94.1934 0.7921 1.0 0.0 1.0
2019-10-03 120.50 126.6470 127.2154 -0.5684 0.0 -1.0 0.0
2019-10-04 123.33 126.2755 127.2970 -1.0215 0.0 0.0 -1.0
2019-12-09 120.06 121.6770 121.4564 0.2206 1.0 1.0 0.0
2019-12-10 122.29 121.8090 121.3954 0.4136 1.0 0.0 1.0
2020-02-13 112.21 123.0760 123.5534 -0.4774 0.0 -1.0 0.0
2020-02-14 113.43 122.3655 123.3598 -0.9943 0.0 0.0 -1.0
2020-04-14 122.78 115.1195 114.9412 0.1783 1.0 1.0 0.0
2020-04-15 123.50 115.4710 114.9242 0.5468 1.0 0.0 1.0
List the signal change and entry/exit points for TW
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-06-14 41.44 43.4150 41.6154 1.7996 1.0 1.0 0.0
2019-06-17 41.82 43.3415 41.7356 1.6059 1.0 0.0 1.0
2019-08-23 44.21 45.5930 45.6032 -0.0102 0.0 -1.0 0.0
2019-08-26 42.90 45.3560 45.6324 -0.2764 0.0 0.0 -1.0
2019-10-30 41.94 40.9200 40.8541 0.0659 1.0 1.0 0.0
2019-10-31 41.75 41.0500 40.7721 0.2779 1.0 0.0 1.0
2020-02-03 46.71 45.5465 45.5606 -0.0141 0.0 -1.0 0.0
2020-02-04 46.33 45.5575 45.5938 -0.0363 0.0 0.0 -1.0
2020-02-19 50.07 46.0720 46.0390 0.0330 1.0 1.0 0.0
2020-02-20 51.68 46.4025 46.1644 0.2381 1.0 0.0 1.0
2020-03-23 36.64 45.7090 46.2175 -0.5085 0.0 -1.0 0.0
2020-03-24 40.35 45.2375 46.1011 -0.8636 0.0 0.0 -1.0
2020-04-22 51.25 47.2740 46.8681 0.4059 1.0 1.0 0.0
2020-04-23 52.52 47.8195 46.9949 0.8246 1.0 0.0 1.0
List the signal change and entry/exit points for TWLO
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-08-12 131.50 139.0715 139.7172 -0.6457 0.0 -1.0 0.0
2020-01-07 108.06 100.2335 99.8402 0.3933 1.0 1.0 0.0
2020-01-08 109.39 100.7535 99.8884 0.8651 1.0 0.0 1.0
2020-03-10 92.61 114.7915 116.0102 -1.2187 0.0 -1.0 0.0
2020-03-11 87.01 112.8715 115.7418 -2.8703 0.0 0.0 -1.0
2020-04-29 111.30 99.0465 98.8836 0.1629 1.0 1.0 0.0
2020-04-30 112.30 100.4150 98.5684 1.8466 1.0 0.0 1.0
List the signal change and entry/exit points for UNH
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-02-05 266.31 260.7970 259.8508 0.9462 1.0 1.0 0.0
2019-02-06 269.50 262.1075 260.0298 2.0777 1.0 0.0 1.0
2019-03-08 237.29 255.6385 256.2386 -0.6001 0.0 -1.0 0.0
2019-03-11 243.15 254.7010 256.2346 -1.5336 0.0 0.0 -1.0
2019-05-29 242.40 240.3350 239.7032 0.6318 1.0 1.0 0.0
2019-05-30 243.50 240.9125 239.4306 1.4819 1.0 0.0 1.0
2019-08-15 244.25 249.6360 249.7646 -0.1286 0.0 -1.0 0.0
2019-08-16 245.69 249.0880 249.8420 -0.7540 0.0 0.0 -1.0
2019-10-28 247.05 232.0600 230.8060 1.2540 1.0 1.0 0.0
2019-10-29 252.29 233.8140 230.9576 2.8564 1.0 0.0 1.0
2020-02-19 305.31 291.0575 291.1710 -0.1135 0.0 -1.0 0.0
2020-02-20 302.13 291.1345 291.6098 -0.4753 0.0 0.0 -1.0
2020-04-24 291.29 264.6675 263.6016 1.0659 1.0 1.0 0.0
2020-04-27 293.98 267.2440 263.4372 3.8068 1.0 0.0 1.0
List the signal change and entry/exit points for VEEV
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-18 106.03 92.6475 91.9840 0.6635 1.0 1.0 0.0
2019-01-22 103.11 93.5320 92.2050 1.3270 1.0 0.0 1.0
2019-08-12 160.00 165.2180 165.2532 -0.0352 0.0 -1.0 0.0
2019-08-13 162.34 164.7830 165.5158 -0.7328 0.0 0.0 -1.0
2019-12-03 147.36 149.0245 148.9624 0.0621 1.0 1.0 0.0
2019-12-04 144.01 149.1910 148.8164 0.3746 1.0 0.0 1.0
2019-12-20 141.87 146.6675 146.9324 -0.2649 0.0 -1.0 0.0
2019-12-23 143.09 146.1585 146.7534 -0.5949 0.0 0.0 -1.0
2020-02-04 154.28 146.1675 145.7280 0.4395 1.0 1.0 0.0
2020-02-05 151.50 146.7825 145.7448 1.0377 1.0 0.0 1.0
2020-03-16 120.93 146.6630 147.4460 -0.7830 0.0 -1.0 0.0
2020-03-17 132.94 145.2090 147.2546 -2.0456 0.0 0.0 -1.0
2020-04-14 173.59 150.1320 149.3550 0.7770 1.0 1.0 0.0
2020-04-15 174.68 152.2190 149.8768 2.3422 1.0 0.0 1.0
List the signal change and entry/exit points for VZ
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-03-12 57.43 56.1110 56.0186 0.0924 1.0 1.0 0.0
2019-03-13 57.66 56.2730 56.0664 0.2066 1.0 0.0 1.0
2019-05-03 57.24 57.7830 57.8602 -0.0772 0.0 -1.0 0.0
2019-05-06 56.91 57.6740 57.8600 -0.1860 0.0 0.0 -1.0
2019-06-13 57.62 57.5940 57.5764 0.0176 1.0 1.0 0.0
2019-06-14 58.28 57.6390 57.5646 0.0744 1.0 0.0 1.0
2019-06-19 57.63 57.4385 57.4722 -0.0337 0.0 -1.0 0.0
2019-06-20 57.34 57.3430 57.4510 -0.1080 0.0 0.0 -1.0
2019-07-01 56.66 57.3135 57.3078 0.0057 1.0 1.0 0.0
2019-07-02 58.13 57.4090 57.3030 0.1060 1.0 0.0 1.0
2019-07-19 56.59 57.4030 57.4330 -0.0300 0.0 -1.0 0.0
2019-07-22 55.50 57.2895 57.4134 -0.1239 0.0 0.0 -1.0
2019-09-05 58.59 56.8820 56.7506 0.1314 1.0 1.0 0.0
2019-09-06 59.06 57.0440 56.7920 0.2520 1.0 0.0 1.0
2019-11-18 59.44 60.0320 60.0360 -0.0040 0.0 -1.0 0.0
2019-11-19 59.50 59.9685 60.0318 -0.0633 0.0 0.0 -1.0
2019-12-11 61.08 60.0805 60.0794 0.0011 1.0 1.0 0.0
2019-12-12 61.17 60.1685 60.1246 0.0439 1.0 0.0 1.0
2020-01-22 60.48 60.2435 60.2638 -0.0203 0.0 -1.0 0.0
2020-01-23 60.51 60.1990 60.2870 -0.0880 0.0 0.0 -1.0
2020-04-22 57.99 55.8670 55.7674 0.0996 1.0 1.0 0.0
2020-04-23 57.59 56.2495 55.7454 0.5041 1.0 0.0 1.0
2020-05-28 55.72 55.4585 55.5166 -0.0581 0.0 -1.0 0.0
2020-05-29 57.38 55.4550 55.5778 -0.1228 0.0 0.0 -1.0
List the signal change and entry/exit points for WING
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-17 67.64 64.6125 64.4134 0.1991 1.0 1.0 0.0
2019-01-18 67.95 64.9185 64.5186 0.3999 1.0 0.0 1.0
2019-03-12 66.84 66.9760 67.0224 -0.0464 0.0 -1.0 0.0
2019-03-13 69.43 66.9125 67.1182 -0.2057 0.0 0.0 -1.0
2019-03-22 72.36 68.0835 67.9336 0.1499 1.0 1.0 0.0
2019-03-25 72.16 68.3750 67.9958 0.3792 1.0 0.0 1.0
2019-09-19 87.47 95.8130 96.4294 -0.6164 0.0 -1.0 0.0
2019-09-20 87.53 94.8790 96.2780 -1.3990 0.0 0.0 -1.0
2019-12-20 86.44 82.2580 81.8691 0.3889 1.0 1.0 0.0
2019-12-23 85.77 82.8235 81.8115 1.0120 1.0 0.0 1.0
2020-03-10 76.15 90.3925 91.0604 -0.6679 0.0 -1.0 0.0
2020-03-11 71.57 89.1210 90.7676 -1.6466 0.0 0.0 -1.0
2020-04-17 107.14 85.0850 84.6116 0.4734 1.0 1.0 0.0
2020-04-20 109.35 87.7285 84.9324 2.7961 1.0 0.0 1.0
List the signal change and entry/exit points for WIX
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-17 103.91 92.95350 92.3286 0.62490 1.0 1.0 0.0
2019-01-18 104.29 93.88800 92.4434 1.44460 1.0 0.0 1.0
2019-09-04 136.75 144.34750 144.5096 -0.16210 0.0 -1.0 0.0
2019-09-05 135.94 143.89200 144.4332 -0.54120 0.0 0.0 -1.0
2019-11-13 135.70 124.36450 123.7882 0.57630 1.0 1.0 0.0
2019-11-14 125.20 124.43250 123.5734 0.85910 1.0 0.0 1.0
2019-12-11 119.55 122.91200 123.2102 -0.29820 0.0 -1.0 0.0
2019-12-12 119.04 122.07900 123.3094 -1.23040 0.0 0.0 -1.0
2020-01-10 140.26 124.52025 124.4011 0.11915 1.0 1.0 0.0
2020-01-13 142.43 125.68975 124.7595 0.93025 1.0 0.0 1.0
2020-03-10 120.90 138.05550 138.4207 -0.36520 0.0 -1.0 0.0
2020-03-11 114.98 136.58850 138.2840 -1.69550 0.0 0.0 -1.0
2020-04-29 134.24 119.33750 119.0404 0.29710 1.0 1.0 0.0
2020-04-30 130.81 121.24700 118.5518 2.69520 1.0 0.0 1.0
List the signal change and entry/exit points for WMT
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-01-25 96.94 95.2230 94.8820 0.3410 1.0 1.0 0.0
2019-01-28 97.06 95.4965 94.7458 0.7507 1.0 0.0 1.0
2019-08-14 106.20 110.0075 110.3658 -0.3583 0.0 -1.0 0.0
2019-08-15 112.69 109.9060 110.5312 -0.6252 0.0 0.0 -1.0
2019-09-06 114.73 111.9285 111.8238 0.1047 1.0 1.0 0.0
2019-09-09 116.33 112.3810 111.9484 0.4326 1.0 0.0 1.0
2020-01-09 117.36 119.0775 119.0794 -0.0019 0.0 -1.0 0.0
2020-01-10 116.38 118.9465 119.0640 -0.1175 0.0 0.0 -1.0
2020-04-09 121.80 116.3505 115.7862 0.5643 1.0 1.0 0.0
2020-04-13 125.30 116.9105 115.9606 0.9499 1.0 0.0 1.0
List the signal change and entry/exit points for WORK
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-12-23 21.53 21.8930 21.8446 0.0484 1.0 1.0 0.0
2019-12-24 21.35 21.8355 21.7792 0.0563 1.0 0.0 1.0
2020-02-05 23.31 22.0155 22.0442 -0.0287 0.0 -1.0 0.0
2020-02-06 22.65 21.9595 22.0738 -0.1143 0.0 0.0 -1.0
2020-02-11 25.98 22.2605 22.2398 0.0207 1.0 1.0 0.0
2020-02-12 25.81 22.4370 22.2996 0.1374 1.0 0.0 1.0
2020-03-27 28.58 24.1540 24.1912 -0.0372 0.0 -1.0 0.0
2020-03-30 28.21 24.2040 24.2960 -0.0920 0.0 0.0 -1.0
2020-04-16 29.38 25.5640 25.2966 0.2674 1.0 1.0 0.0
2020-04-17 28.10 25.9185 25.3924 0.5261 1.0 0.0 1.0
List the signal change and entry/exit points for ZM
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-06-28 88.79 92.4890 82.2626 10.2264 1.0 1.0 0.0
2019-07-01 86.86 93.0370 82.7598 10.2772 1.0 0.0 1.0
2019-08-19 93.17 94.4005 94.5386 -0.1381 0.0 -1.0 0.0
2019-08-20 91.41 94.1015 94.3268 -0.2253 0.0 0.0 -1.0
2019-12-05 69.67 70.4735 70.3392 0.1343 1.0 1.0 0.0
2019-12-06 62.74 70.2700 69.9990 0.2710 1.0 0.0 1.0
2019-12-24 66.46 67.6480 67.9198 -0.2718 0.0 -1.0 0.0
2019-12-26 67.45 67.2625 67.8466 -0.5841 0.0 0.0 -1.0
2020-01-14 73.16 69.0215 68.9386 0.0829 1.0 1.0 0.0
2020-01-15 76.94 69.5510 69.0696 0.4814 1.0 0.0 1.0
List the signal change and entry/exit points for ZS
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-08-23 71.28 80.08700 80.5148 -0.42780 0.0 -1.0 0.0
2019-12-02 51.07 46.51700 46.2351 0.28190 1.0 1.0 0.0
2019-12-03 52.80 46.93900 46.2847 0.65430 1.0 0.0 1.0
2020-03-10 47.01 55.03300 55.3328 -0.29980 0.0 -1.0 0.0
2020-03-11 42.88 54.13100 55.2382 -1.10720 0.0 0.0 -1.0
2020-04-08 64.93 56.05175 55.7581 0.29365 1.0 1.0 0.0
2020-04-09 62.59 57.20625 55.8673 1.33895 1.0 0.0 1.0
List the signal change and entry/exit points for ZTS
close fast_ma slow_ma ma_change signal signal_chg entry_exit
2019-02-14 93.26 86.0835 86.0100 0.0735 1.0 1.0 0.0
2019-02-15 95.37 86.6395 86.0460 0.5935 1.0 0.0 1.0
2019-11-08 117.86 124.7855 124.8702 -0.0847 0.0 -1.0 0.0
2019-11-11 117.03 124.3075 124.6824 -0.3749 0.0 0.0 -1.0
2019-12-20 132.68 123.2395 123.0546 0.1849 1.0 1.0 0.0
2019-12-23 132.37 123.8675 123.1326 0.7349 1.0 0.0 1.0
2020-03-12 120.28 137.4255 137.4874 -0.0619 0.0 -1.0 0.0
2020-03-13 125.48 136.4525 137.3500 -0.8975 0.0 0.0 -1.0
2020-04-30 129.31 125.2510 124.1994 1.0516 1.0 1.0 0.0
2020-05-01 127.53 125.8260 123.8790 1.9470 1.0 0.0 1.0
In [27]:
for ticker in stock_list:
graph_data = dataframe_collection[ticker][:]
fig = plt.figure(figsize=(16,9))
ylabel = ticker + ' Price ($)'
ax1 = fig.add_subplot(111, ylabel=ylabel)
graph_data['fast_ma'].plot(ax=ax1, color='b', lw=2.)
graph_data['slow_ma'].plot(ax=ax1, color='r', lw=2.)
graph_data['close'].plot(ax=ax1, color='g', lw=2.)
ax1.plot(graph_data.loc[graph_data.entry_exit == 1].index, graph_data.close[graph_data.entry_exit == 1], '^', markersize=7, color='k',label='buy')
ax1.plot(graph_data.loc[graph_data.entry_exit == -1].index, graph_data.close[graph_data.entry_exit == -1], 'v', markersize=7, color='k',label='sell')
plt.legend()
plt.show()
In [28]:
if notifyStatus: email_notify("Task 3. Develop Strategy and Train Model completed! "+datetime.now().strftime('%a %B %d, %Y %I:%M:%S %p'))
Task 4. Back-test Model¶
In [29]:
if notifyStatus: email_notify("Task 4. Back-test Model has begun! "+datetime.now().strftime('%a %B %d, %Y %I:%M:%S %p'))
In [30]:
# Not applicable for this iteration of the project
In [31]:
if notifyStatus: email_notify("Task 4. Back-test Model completed! "+datetime.now().strftime('%a %B %d, %Y %I:%M:%S %p'))
Task 5. Evaluate Performance¶
In [32]:
if notifyStatus: email_notify("Task 5. Evaluate Performance has begun! "+datetime.now().strftime('%a %B %d, %Y %I:%M:%S %p'))
In [33]:
# Not applicable for this iteration of the project
In [34]:
if notifyStatus: email_notify("Task 5. Evaluate Performance completed! "+datetime.now().strftime('%a %B %d, %Y %I:%M:%S %p'))
In [35]:
print ('Total time for the script:',(datetime.now() - startTimeScript))
Total time for the script: 0:06:50.952676